mySQL and timestamp - weird behaviour

admin

Administrator
Staff member
this is my first php project ... so this might be a really basic question.

i have a page where people select a date (using 3 selectors for day, month, year). before i store the date in the mySQL database i want to make it a timestamp (the fields are of type 'timestamp'). so i do this:
$ShootingStart = mktime (0,0,0,$SetSSm,$SetSSd,$SetSSy);
i then take $ShootingStart and do a regluar INSERT INTO

when i check the db theres just a bunch of 0s in the field and not the actual timestamp.

any suggestions?

thanks in advance
xaver
 
Back
Top