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

Geoff Cox schreef:
use the date/time from your server, not from 'any' client posting.

--
Luuk

On Sat, 10 May 2008 09:36:40 +0200, Luuk <Luuk (AT) invalid (DOT) lan> wrote:

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

Geoff Cox schreef:
http://dev.mysql.com/doc/refman/5.0/...functions.html

--
Luuk

On May 10, 12:37*pm, Luuk <L... (AT) invalid (DOT) lan> wrote:
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

On Sat, 10 May 2008 10:26:50 +0200, Geoff Cox <gcox (AT) freeuk (DOT) notcom> wrote:


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

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]

Rik Wasmus wrote:

and if you don't want to make "code" changes - add a timestamp column to
your table and add a trigger to automatically update it.

See the docs for BEFORE INSERT,UPDATE triggers.