SELECT FROM WHERE Syntax

[rapmonkey]

Hi, I am having a problem with a SELECT FROM WHERE syntax. I want to be able so select a certain row in a table, and the row must depend on a variable that is supplied. For code I have:

$query = "SELECT * FROM $userstable WHERE codename = $gname";

Whats wrong? 😕

[merkinmuffley]

probably you're just missing single quotes around the value. all character values used in the WHERE clause have to be enclosed in single quotes.

select * from $userstable where codename='$gname'