Posted by ED on 05/17/06 16:52
"monomaniac21" <mcyi2mr3@googlemail.com> wrote in message
news:1147869686.245426.298350@i40g2000cwc.googlegroups.com...
> Hi all can mysql be queried so it finds and then adds the current date
> to a field without requiring a php function to get the date for it?
>
By 'add' I presume you mean just set the current date, in which case:
"UPDATE my_table set my_datefield = CURDATE()";
cheers,
ED
Navigation:
[Reply to this message]
|