NYCPHP Meetup

[Phil Powell]

I honestly have found nothing on www.mysql.com or anywhere else that can address this problem.  All I simply want to do is to delete rows from a table where nnet_produkt_record_entered is more than 24 hours old.  I thought this would do it but it produces a mysql_error near 'HOURS)':

   $sql = 'DELETE FROM nnet_produkt_bestilling ' .
          'WHERE nnet_produkt_placement < DATE_SUB(NOW(), INTERVAL 24 HOURS)';

Any ideas, sorry I'm fresh out as usual.

Thanx
Phil
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20031005/d3103d19/attachment.html>