On Fri, 13 Aug 2004 00:08:56 -0500, Dylan Barber <dylan.barber@xxxxxxxxxxxxx> wrote: > I have a tracking database but I only need things in it for about an hour > > I tried this > > DELETE * FROM `tblDownloadTrack` WHERE `timestamp` < TIME_TO_SEC( NOW( ) ) > > but it gives me an error anybody help me out on this? > > MySQL 4.0.16 > You need to give us an error. Perhaps: DELETE * FROM `tblDownloadTrack` WHERE `timestamp` < DATE_SUB(NOW( ), INTERVAL 1 HOUR) -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
