Re: Emptying mySQl database on time-based factor!!!

man crontab, man cron, or www.linuxhelp.org --Joe On Sat, Nov 25, 2000 at 04:06:00AM -0800, Thomas Edison Jr. wrote: > I guess "Popular Opinion" says i should use the > crontab method for my job....then i guess i'll go for > that.... > > Just tell me where i can get to read up on the cron/ > crontab thing? How i can actually use this scriptwise > for my job..... > > Thanks a lot guys, > > Regards, > T. Edison jr. > > > You could write a crontab PHP script to do it. > > > Add a timestamp column to each table, and simple > > have a series of: > > $query = "delete from blah where update + '@ 2 > > hours' <= now() and name = > > 'criteria'"; > > mysql_query($query); > > > > ===== > Rahul S. Johari (Director) > ****************************************** > Abraxas Technologies Inc. > Homepage : http://www.abraxastech.com > Email : abraxastech@yahoo.com > Tel : 91-4546512/4522124 > ******************************************* > > __________________________________________________ > Do You Yahoo!? > Yahoo! Shopping - Thousands of Stores. Millions of Products. > http://shopping.yahoo.com/ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net ================================================================================ = Joe Stump joestump98@yahoo.com http://www.miester.org = ================================================================================ Need a programmer? http://www.google.com/search?q=joe+stump+resume