On Sat, 10 May 2008 09:36:40 +0200, Luuk <Luuk@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