Re: Date

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux