Re: Deleting older records
| From: | Ng Hwee Hwee | Date: | Fri, 13 Aug 2004 05:14:41 +0000 |
| Subject: | Re: Deleting older records | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35677@lists.php.net to get a copy of this message | ||
what was the error??
----- Original Message -----
From: "Dylan Barber" <dylan.barber@earthlink.net>
To: <php-db@lists.php.net>
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%20Data/Microsoft/Si
> gnatures/www.codegalaxy.com> www.codegalaxy.com - A webservices company
>
> DotNetNuke Portal Specialists
>
> Simple Affordable & Reliable - Web Design, and Programming
>
>
>