On 6/19/07, Richard Heyes <richardh@xxxxxxxxxxx> wrote:
Shafiq Rehman wrote: > Hello, > > There's another way out there using mysql > > SELECT DATE_ADD('$expiry_date', INTERVAL 7 DAY) as fDate > > but of course not a recommended way. So why suggest it?
just to share the knowledge
In fact you can use it update query > (update tbl_name set expiry_date = date_add('$expiry_date', INTERVAL 7 DAY) > where user ='$user') Seriously, no. -- Richard Heyes 0844 801 1072 http://www.websupportsolutions.co.uk Knowledge Base and HelpDesk software
-- Shafiq Rehman (ZCE) http://www.phpgurru.com | http://shafiq.pk Cell: +92 300 423 9385