try

DELETE FROM `tblDownloadTrack` WHERE `timestamp` <  TIME_TO_SEC( NOW( ) )

----- Original Message ----- 
From: "Dylan Barber" <[EMAIL PROTECTED]>
To: "'Ng Hwee Hwee'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 13, 2004 1:17 PM
Subject: RE: [PHP-DB] Deleting older records


> 1064 - 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
'*
> FROM  `tblDownloadTrack`  WHERE  `timestamp`  < TIME_TO_SEC(
>
>
> Dylan Barber
>
> www.codegalaxy.com - A webservices company
>
> DotNetNuke Portal  Specialists
>
> Simple Affordable & Reliable - Web Design, and Programming
>
>
>
> > -----Original Message-----
> > From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED]
> > Sent: Friday, August 13, 2004 12:15 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [PHP-DB] Deleting older records
> >
> > what was the error??
> >
> > ----- Original Message -----
> > From: "Dylan Barber" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, August 13, 2004 1:08 PM
> > Subject: [PHP-DB] Deleting older records
> >
> >
> > > 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
> > >
> > >
> > > Dylan Barber
> > >
> > >
> > >
> > <file:///C:/Documents%20and%20Settings/Dylan/Application%20Dat
> > a/Microsoft/Si
> > > gnatures/www.codegalaxy.com> www.codegalaxy.com - A
> > webservices company
> > >
> > > DotNetNuke Portal  Specialists
> > >
> > > Simple Affordable & Reliable - Web Design, and Programming
> > >
> > >
> > >
> >
> > -- 
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to