Hi there,
Can anyone help please. It seems that my code as below is not passing the variable content to my WHERE clause in my MySQL query. If I do an echo on it, the value displays, but when I look at the query using echo "Query: $q"; my value is empty. Please help.
$username = $session->username;
global $database;
$q = sprintf("SELECT plot, username, timestamp, buyer1 FROM pricelist where status=2 and username ='%s' LIMIT 0,30",
mysql_real_escape_string($username));
echo "Query: $q";
$result = mysql_query($q);
/ Error occurred, return given name by default /
$num_rows = mysql_numrows($result);
if(!$result || ($num_rows < 0)){
echo "Error displaying info";
return;
}
