On May 10, 12:37*pm, Luuk <L...@invalid.lan> wrote:
> Geoff Cox schreef:
>
>
>
> > On Sat, 10 May 2008 09:36:40 +0200, Luuk <L...@invalid.lan> wrote:
>
> >> Geoff Cox schreef:
> >>> Hello,
>
> >>> I have pages using AJAX and php to add data to MySQL database.
>
> >>> What's the best way to add the date/time fror each addition of data?
>
> >>> Thanks
>
> >>> Geoff
> >> use the date/time from your server, not from 'any' client posting.
>
> > Luuk,
>
> > Thanks for your reply.
>
> > I have just tried adding this to the php file and it seems to work OK.
>
> > 1. in the php file
>
> > $dt1 = date("Y-m-d H:i:s");
>
> > 2. to create in MySQL
>
> > dt1 datetime NOT NULL default '0000-00-00 00:00:00',
>
> > Is this not a good idea?
>
> > How would I get the server date/time into MySQL?
>
> > Cheers
>
> > Geoff
>
> http://dev.mysql.com/doc/refman/5.0/...functions.html
>
> --
> Luuk

if you really only want to get the creation time why not use a
timestamp column that automatically saves the last update time?

saee: http://dev.mysql.com/doc/refman/5.0/en/timestamp.html
CVH