Unknown column

[Marcel1993]

Hey,

 

I've got a query in which a variable is interpreted as a column and I don't why this is caused.

 

$upgrade_time_sql = "SELECT * FROM todo_upgrades WHERE profile_id = ".$profile_id." AND level = ".$profile_data['level2_'.$show.'']." AND type = ".$show."";
$upgrade_time_res = mysql_query($upgrade_time_sql) or die (mysql_error());

 

$show is filled with the content "storage"

 

The mysql_error is

 

"Unknown column 'storage' in 'where clause'"

 

Thanks for helping.

[BlueSkyIS]

echo the SQL to see what it looks like.

 

$upgrade_time_res = mysql_query($upgrade_time_sql) or die (mysql_error() . " IN $upgrade_time_sql");

[PFMaBiSmAd]

String data needs to be enclosed in single-quotes to make it string data, otherwise it is treated as an identifier (database, table, or column name.)

[Marcel1993]

Hey, thats was it :-)

 

Thank you very much! :-)