my mysql_query doesnt work?!?

[flemingmike]

here is my code, it doesnt work though:

 

mysql_query("DELETE FROM findamatch WHERE NOW() - 3 HOUR > $timestamp");

[Maq]

 

mysql_query("DELETE FROM findamatch WHERE NOW() - 3 HOUR > $timestamp") or die(mysql_error());

[flemingmike]

i get this error now:

 

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 'HOUR > 1237561603' at line 1

[Mchl]

NOW() - 3 HOUR is not correct MySQL syntax

Try NOW() - 030000

[flemingmike]

i tried that, it just removed all the entries though, even new ones.

 

here is the format of my timestamp 2009-03-20 10:28:26

 

here is my code:

 

mysql_query("DELETE FROM findamatch WHERE NOW() - 030000 > $timestamp") or die(mysql_error());

[revraz]

You don't specify what FIELD your timestamp is in.

[flemingmike]

$fam=mysql_query("SELECT id,clan,rules,month,day4,year,hour,min,ampm,timezone,teamid,ladder,maxbet,aim,email,yim,timestamp FROM findamatch ORDER BY timestamp");
while(list($id,$clan,$rules,$month,$day4,$year,$hour,$min,$ampm,$timezone,$teamid,$ladder,$maxbet,$aim,$email,$yim,$timestamp)=mysql_fetch_row($fam)){

[flemingmike]

anyone have any ideas?

[Mchl]

Maybe. Just write what you want to achieve actually.

[Maq]

$fam=mysql_query("SELECT id,clan,rules,month,day4,year,hour,min,ampm,timezone,teamid,ladder,maxbet,aim,email,yim,timestamp FROM findamatch ORDER BY timestamp");
while(list($id,$clan,$rules,$month,$day4,$year,$hour,$min,$ampm,$timezone,$teamid,$ladder,$maxbet,$aim,$email,$yim,$timestamp)=mysql_fetch_row($fam)){

 

No one knows what this is or what it is supposed to do, nor can we read that.

[revraz]

What field name do you want the Delete based on?

What does $timestamp variable contain?

If you echo the query, what does it look like?