Posted by Jerim79 on 11/21/06 17:44

I need to take the output from a query and convert it to lower case.
Here is the relevant code:

$query="SELECT FNAME, LNAME FROM (table) WHERE FNAME=('$FName') AND
LNAME=('$LName')";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());


I can get number of rows by using mysql_num_rows($result) so I assume
there is some similar method for accessing data in the $result
variable. This didn't seem to work: $result=strtolower($result);
Also changing the query to read LNAME=strtolower('$LName') didn't
work either. I am just looking for a way to access the FNAME and the
LNAME in the $result variable.

[Back to original message]