Site Cloner PHP Script
Bargain Hunter PHP Script
Job Hunter PHP Script
Site Login and Access Control PHP Script

MYSQL LOWER() And UPPER() Functions

The upper() and lower() functions with mySQL can be used to change selected data into lower case or upper case values. These functions are very similar to PHP strtolower() and strtoupper() functions.

$db = public_db_connect();
//MYSQL LOWER() and UPPER() Functions

$command = “SELECT DISTINCT LOWER(firstname) as first, UPPER(lastname) as last, LOWER(Email) as email FROM table_sort WHERE id >0 ORDER BY last ASC” ;
$result = mysqli_query($db, $command);
while($row = mysqli_fetch_assoc($result)){
$firstname = $row[‘first’];
$lastname = $row[‘last’];
$email = $row[’email’];
echo $firstname.”-“.$lastname.”-“.$email.”<br/>”;