Don't know why a SQL query doesn't work

[Marcel1993]

Hey,

 

$todo_upgrades_sql = "SELECT * FROM todo_upgrades WHERE time_completion >= $time";
$todo_upgrades_res = mysql_query($todo_upgrades_sql) or die (mysql_error());

results:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[Pikachu2000]

Are you sure $time has a value?

[shlumph]

It'd help to show the declaration of $time, as it's also part of the query. If you're using datetime, or date, you'll have to surround $time with quotes.

[Marcel1993]

Hey,

 

$time has been defined before as

 

$time = time();

[PFMaBiSmAd]

You need to echo the query so that you can see what it actually is, but the error is typical of the $time variable not having a value when the query was executed.

[Marcel1993]

Hey,

 

thanks. As you said above the variable was without content. It was because the query was surrounded by a function - so I made a condition of the var filled with the time-content.

 

Thank you very much!