In message <[EMAIL PROTECTED]>, Marian Briones <[EMAIL PROTECTED]> writes >Yeah, I thought of setting up a cron job, maybe to fire at midnight or >something like that - to delete the records. It's a messaging system. > I have shell access on my server; I turn it on and off for domains so >I don't get invaded (it's happened). > >I was thinking either that, or every time the data is queried it could >delte, but if it's a load on MySQL to do that, then the cron job is >the better alternative.
Of course, your SELECT could return only records that were > MyDate. That way, you wouldn't need to DELETE as often. I certain wouldn't do it the way that I read your original post - "You want a SELECT? Wait till I have DELETED first" - I hate to keep my customers waiting more than the odd squillisecond. -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
