> However, I would suggest, if you have control of the search > tools, that you simply put in an extra timestamp field called > "hideuntil" into your database, and add conditions into your > searches that drop rows for which hideuntil is not null and is > after the current time.
This is a great idea and I do have control over the search tool. The search tool is a static SQL query, so I think (without testing), I will need something like: SELECT * from Messages WHERE hideuntil >= (NOW()+0) hideuntil is a timestamp(14) and is set so that it will never be null. Because it is a timestamp, if it is left blank, it will default to the current time/date. I will have a play on the system on Monday, but that seems about right to me. Cheers, Ben --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
