Quick question on query!!!

[snowman15]

Hey everyone, for some reason, this script isnt working. It just doesn't echo anything. What is wrong with my syntax?

 

$query="SELECT *
FROM `users`
WHERE `user` LIKE $username;";
$result = $db->query($query);
$row= $result->fetch_assoc();
$fname=$row['first'];
$lname=$row['last'];
echo "$fname $lname";

 

 

 

assuming $username is set

[fenway]

Other than the trailing semicolon in the query that shouldn't be there, this is clearly a DB class.  How do you know you're getting any rows back?

[Barand]

String variables need quotes otherwise SQL thinks they are column names. Check the value of mysql_error()

 

$query="SELECT *

FROM `users`

WHERE `user` LIKE '$username' ";