[SOLVED] Newb Question About Datetime

[uwannadonkey]

i put a datetime column in my mysql table

 

what php code do i need to get the time and add it into the table?

[dbo]

Are you looking for the current time? If so I think there is a function in MySQL that will timestamp stuff for you and you won't need to do this in PHP at all.

 

Otherwise search php.net for date() and time() functions.

[uwannadonkey]

i have created a table for battle logs. i want to record the time of battle

 

i added the columns ID, winner, loser, and TIME(datetime)

 

when i added first battle there was no time, how do i add that

?

[dbo]

What do you mean?

[uwannadonkey]

i insert winner, and loser

and the ID was auto

but the datetime is still 0000-00-00 00:00:00

 

how do i record the time

[reages]

your probably refering to the format.  the format that you see, 0000-00-00 00:00:00, is YYYY-MM-DD HH:MM:SS.

 

for simplicity, let's use date() (and the current local time): date ("Y-m-d H:i:s");.

 

don't forget to insert the TIME(datetime) as string, ie:

$sql = "INSERT INTO ... values (..., '" . date ("Y-m-d H:i:s") . "')"

 

regards.

[akitchin]

alternatively, you can just use MySQL's NOW() function to insert the current date and time, in the proper format:

 

$sql = "INSERT INTO ... values (..., NOW())"

[uwannadonkey]

thanks!