This works just fine thanks
-Original Message-
From: Nadim Attari <[EMAIL PROTECTED]>
Sent: Aug 13, 2004 1:12 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Deleting older records
> Okay I have a timestamp field how do I create a query to delete all
entries
> older
> Okay I have a timestamp field how do I create a query to delete all
entries
> older than an hour. Timestamp field is set by now() function.
DELETE FROM tblDownloadTrack WHERE `timestamp` <
TIME_TO_SEC(DATE_SUB(NOW( ), INTERVAL 1 HOUR))
--
PHP Database Mailing List (http://www.php.net/)
To uns
; '$time'";
mysql_query($query);
- Original Message -
From: "Dylan Barber" <[EMAIL PROTECTED]>
To: "'Ng Hwee Hwee'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 13, 2004 1:32 PM
Subject: RE: [PHP-DB] Deleti
e Portal Specialists
Simple Affordable & Reliable - Web Design, and Programming
> -Original Message-
> From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 13, 2004 12:23 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Deleting older records
>
> try
&
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
Affordable & Reliable - Web Design, and Programming
> -Original Message-
> From: Dylan Barber [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 13, 2004 12:17 AM
> To: 'Ng Hwee Hwee'; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Deleting older records
>
&g
cialists
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 wa
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
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
www.codegalaxy.com - A webservices comp