insert php generated datetime to mysql

[Anon]

I am generating a test in php. I'm having trouble with 2 variables defined below.

$start_time=time();
$end_time=time();

the start time passes through hidden fields until the test is done.

my problem is inserting them into the mysql database at the end of the test. I've created a table named "test_results" and 2 fields called "start_time" and "end_time".

I'm not sure what type to set those mysql fields. No matter what i set it to, either timestamp or date/time, i am getting all 0's in the results. ie: 0000-00-00 00:00:00

any suggestions?

[Anon]

the time() function returns a unix timestamp. so you are going to want to store the time stamp in an int type field in the mysql database.

[Anon]

You need to change the format of the timestring being sent to mysql. Mysql takes the date and time fields.

the time command in php returns the unix time format, which mysql does not accept.

Use the Date command in PHP to convert it to the correct format before entering the database. If you format the date incorrect mysql will enter the 0000-00-00 00:00:00 instead.

Helpful URL:
http://www.php.net/manual/en/function.date.php

Greg