date question...

[_0_05_]

okay, i have a form that people have to fill out, and i have drop down menues for month, day, and year, now what i want to do is put all that info into a mysql database, then take it out, in order of date - in what format do i put it in, so i can just do a sql query and order by date desc/asc?

ie:
select * from table order by date desc

[CrimsonSoul]

A MySQL Timestamp is in the format of:

YYYY-MM-DD-HH.MM.SS.ssssss

All you'd need to do is append the values together like so:
$time_stamp = "$year-$month-$day-00.00.00.000000"

Hope this helps. 🙂

[barand]

Define your date field as DATE type, but don't call it 'Date' as its a reserved word. Use order_date or date_of_ birth etc.

When processing your form, assuming your selects are called day, month and year:-

$year = $_POST['year'];
$month = $post['month'];
$day = $_POST['day'];
$otherdata = $_POST['otherdata']; 

// put date in yyyy-mm-dd format
$theDate = sprintf('%d-%02d-%02d', $year,$month,$day)";
$sql = "INSERT INTO mytable (thedate, otherdata) VALUES
           ('$thedate', '$otherdata');

hth