On Sat, 10 May 2008 10:26:50 +0200, Geoff Cox <gcox@freeuk.notcom> wrote:

> 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',


I usually rather have NULLs for no data, then an invalid one (there is no
year 0).

> Is this not a good idea?
> How would I get the server date/time into MySQL?

NOW()
--
Rik Wasmus
[SPAM] Now temporarily looking for some smaller PHP/MySQL projects/work to
fund a self developed bigger project, mail me at rik at rwasmus.nl. [/SPAM]