Re: FN-FORUM mysql date delete

date posted 27th June 2002 16:01

Hi Rob,

You'd need to create a PHP script that would delete the database entries
(using normal SQL statements) when run, and then set this up as a cron job
so that it is executed periodically. Rather than go through all this here,
I've dug up a couple of tutorials on the Internet you might want to look
at...

CRON Basics
http://www.linux-tutorial.info/cgi-bin/display.pl?78&0&0&0&3

Running PHP scripts with CRON
http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=388&lngWId=8

I hope this helps!

Regards,

Steve

----- Original Message -----
From: "Rob Garbutt" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, June 27, 2002 2:56 PM
Subject: FN-FORUM mysql date delete


Hi all,

I have 2 fields in a mysql database. One is the start date of an event
called 'start' and one is the end date of an event called 'end'

I want to make the database delete entries automatically when the 'end' date
is greater than the system date.

I use php as a front end.

how would you go about this utilising either php or mysql?

tia!

Robin Garbutt
Portfolio Art & Design Ltd
Tel - +44 (0) 1204 383822
Fax - +44 (0) 1204 383866
Mob - +44 (0) 7811 185490
e-mail - [EMAIL REMOVED]

For further information please visit us at :-
www.portfoliodesign.net