[SOLVED] Delete rows belonging to datetime

[[email protected]]

..

$query =  mysql_query("DELETE FROM *table* WHERE datetime > 3 days back")or die(mysql_error());

 

My error?

[[email protected]]

 

Any HELP

 

$query_users = mysql_query("DELETE FROM *table* WHERE date_time < SYSDATE - 3 ")or die(mysql_error());
//I am trying to delete all data 3 days old

[Maq]

What's the error?

 

1) Not sure what *table* is.

2) Which query are you using?

[[email protected]]

Fixed it!!

thanks though Maq

 

  $query_users = mysql_query("DELETE FROM test1 WHERE date_time < (curdate() - 2)")or die(mysql_error());