can anyone tell me what is wrong with this query


$time=time();
$timeout = $time - 1200;

mysql_query("delete from ut_temp where time<$timeout") or die('Error In Deletion of Temp Value');

First try putting $timeout in single quotes, but failing that replace 'Error in deletion of Temp Value' with mysql_error(), and it will tell you what's wrong!

As I said at DBF...

I'm thinking it's because of your "time" field. "time" is a mySQL keyword, so if you want to use it as a field name, you must enclose it in backticks.

Also, try add the mysql error message to your die() so you know what is going on next time.

mysql_query("delete from ut_temp where `time` < $timeout") or die('Error In Deletion of Temp Value - Error: ' . mysql_error());