Help With select Query

[golfinggod]

Hi I have a select query that is driving me nuts. If I type this it works

$variety = "Asiatic";

				echo $variety;

				mysql_connect("", "", "") or die(mysql_error());
				mysql_select_db("db122078148") or die(mysql_error());

				$result = mysql_query("SELECT * FROM Products WHERE Catagory = 'Asiatic' ")or die(mysql_error());

But if I then use this

$variety = "Asiatic";

				echo $variety;

				mysql_connect("", "", "") or die(mysql_error());
				mysql_select_db("db122078148") or die(mysql_error());

				$result = mysql_query("SELECT * FROM Products WHERE Catagory = $variety ")or die(mysql_error());

it produces this error

AsiaticUnknown column 'Asiatic' in 'where clause'

Can someone point me in the proper direction I would like to use thew second query

Thanks

[laserlight]

You forgot to (single) quote the string $variety in the SQL statement, so after variable interpolation is done, it looks like you have a column named "Asiatic" that you wish to refer to.

[diego25]

A good way of debugging SQL queries is to output them. For your problem, you're missing single quotes:

$result = mysql_query("SELECT * FROM Products WHERE Catagory = '$variety' ")

[golfinggod]

Thanks All Really Helped

🙂