Re: how to auto delete by PHP+MYSQL in a given time?

Unfortunately there is no way using MySQL (prior to v.4.0) to do this. The process is called a stored procedure. You tell the DB to perform a query after 'X' period of minutes, hours, days etc. At the moment if you're using Unix/Linux boxes then you can use 'crontab'. This is a program that you instruct via the command line to execute a batch file of commands every 'X' minutes etc. Go to: http://www.superscripts.com/tutorial/crontab.html for a tutorial. On Windoze I think you need to use something called 'AT', but I don't know much about that either. There was a post on this a few days ago. Take a look at the archives. Good luck. Russ On Thu, 8 Nov 2001 12:42:29 +0800 Web user <random11@telekbird.com.cn> wrote: > A new user sign up an account, but don't activate it in a given time, So his > sign-up record need to be deleted from the db. > Can I use PHP+MYSQL to delete it automatically in a given time, if yes, > could you please tell me how? > > Regards > Mike > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: r.j.michell@apu.ac.uk w: www.apu.ac.uk/webteam www.theruss.com #-------------------------------------------------------#