Need help inserting current timestamp into mysql

theMAD2 · 8 Aug 2006 at 10:39

I've got a table with a field TIMESTAMP, but I've tried everything I can think of and still can't get the current timestamp in there. I'm using php to insert the data, should I be using php to generate the time and date then insert the numbers, or should I use timestamp with default to CURRENT_TIMESTAMP in mysql?

Thanks

theMAD2 · 8 Aug 2006 at 10:44

Sorry mate, no joy. The date field is a timestamp at the moment, should I be using datetime? When I'm printing it back I'm just getting 0000-00-00 00:00:00 s

theMAD2 · 8 Aug 2006 at 10:57

Thanks for your help, I managed to sort it in the end by inserting $date in this:

Code:

$date = date('Y-m-d H:i:s');

into a datetime field.

theMAD2 · 8 Aug 2006 at 12:08

Beansprout said:
NOW()

I tried that and it didn't seem to work. Do you put that in the default value?