problem somewhere

[stew]

hey there guys,

i've got the following snippet of a code

$date = mktime(0, 0, 0, $year, $month, $day);

basically, im trying to convert the year, month and day variables into a single date variable in the form yyyy-mm-dd (which im told is the standard form for a MySQL database.

anyway... when i submit the form, the date in the row appears as 0000-00-00 ! can anyone help?

[rIkLuNd]

why don't you just use this?

$date = date('Y-m-d', mktime(0, 0, 0, $year, $month, $day));

[stew]

hmm...

ive tried that and dates are now entered as 1969-12-31

er.. what?

[xblue]

well if you've already got $day, $month and $year I don't really see why you would want to convert them.

e.g.
SELECT * FROM table WHERE datefield < '$year-$month-$day'
works fine for me (no matter whether it is 02-2-3 or 2002-02-03).

(btw, unix timestamps only start at 1970, that's why the other suggestion fails for older dates.)

[rIkLuNd]

k ,thx for the tip!