[SOLVED] Unknown column '$variable' in 'where clause'

[warstormer]

Hi,

 

I'm getting a: Unknown column 'DW' in 'where clause' error, where DW is passed in a query string 'products.php?prodid=DW' and turned into the variable $prodid_query. The actual query is:

 

$result = mysql_query("select * from products_tbl WHERE prod_id = $prodid_query LIMIT 0, 30 ") or die(mysql_error());

 

The table field 'prod_id' is set as varchar. The strange thing is if I alter the data and use '01' as the $prodid_query variable it works fine...

[wildteen88]

wrap $prodid_query with in quotes:

$result = mysql_query("select * from products_tbl WHERE prod_id = '$prodid_query' LIMIT 0, 30 ") or die(mysql_error());

 

MySQL will treat the value of $prodid_query as a column name and not a string.

[warstormer]

wrap $prodid_query with in quotes:

$result = mysql_query("select * from products_tbl WHERE prod_id = '$prodid_query' LIMIT 0, 30 ") or die(mysql_error());

 

MySQL will treat the value of $prodid_query as a column name and not a string.

 

so simple, and of course works.... Thanks for the help!