sort on date code

[akela]

I am would like to sort my date.
When there putting info on the site, then the messages must be sorted by date. How can I do this?

With this code i get the info of the database
This is not the whole code, just the part of the date

// Vanuit array toewijzen van variabelen van de array $rij

$daystart = substr($rij["daystart"],0,2);
$monthstart = substr($rij["monthstart"],0,8);
$yearstart = substr($rij["yearstart"],0,4);
$plaats_uur = $rij["plaats_uur"];
$uitleg = $rij["uitleg"];

// Opbouwen van tabel
echo "\n\n<table width=100%>\n";
echo "<tr><td> Datum : </td><td><b> $daystart $monthstart $yearstart</b></td></tr>\n";
echo "<tr><td> Plaats en uur : </td><td><b> $plaats_uur </b></td></tr>\n";
echo "<tr><td> Uitleg over activiteit : </td><td><b> $uitleg </b></td></tr>\n";
echo "</table>\n";
echo "<hr>";
}

---

With this code i put info in the database.
This is not the whole code, just the part of the date
<?
//Date listing for use in forms, echo'd in php tags
echo '<b>Dag:</b> <select name="daystart" style="font-size:10px;border:solid 1px";>';
echo'<option value="01">01</option>';
echo'<option value="02">02</option>';
echo'<option value="03">03</option>';
echo'<option value="04">04</option>';
echo'<option value="05">05</option>';
echo'<option value="06">06</option>';
echo'<option value="07">07</option>';
echo'<option value="08">08</option>';
echo'<option value="09">09</option>';
echo'<option value="10">10</option>';
echo'<option value="11">11</option>';
echo'<option value="12">12</option>';
echo'<option value="13">13</option>';
echo'<option value="14">14</option>';
echo'<option value="15">15</option>';
echo'<option value="16">16</option>';
echo'<option value="17">17</option>';
echo'<option value="18">18</option>';
echo'<option value="19">19</option>';
echo'<option value="20">20</option>';
echo'<option value="21">21</option>';
echo'<option value="22">22</option>';
echo'<option value="23">23</option>';
echo'<option value="24">24</option>';
echo'<option value="25">25</option>';
echo'<option value="26">26</option>';
echo'<option value="27">27</option>';
echo'<option value="28">28</option>';
echo'<option value="29">29</option>';
echo'<option value="30">30</option>';
echo'<option value="31">31</option>';
echo '</select>';
echo '<b>Maand:</b> <select name="monthstart" style="font-size:10px;border:solid 1px";>';
echo'<option value="Januari">Januari</option>';
echo'<option value="februari">februari</option>';
echo'<option value="februari">maart</option>';
echo'<option value="april">april</option>';
echo'<option value="mei">mei</option>';
echo'<option value="juni">juni</option>';
echo'<option value="juli">juli</option>';
echo'<option value="augustus">augustus</option>';
echo'<option value="september">september</option>';
echo'<option value="oktober">oktober</option>';
echo'<option value="november">november</option>';
echo'<option value="december">december</option>';
echo'</select>';
echo '<b>Jaar</b> <select name="yearstart" style="font-size:10px;border:solid 1px";>';
echo'<option value="2003">2003</option>';
echo'<option value="2004">2004</option>';
echo'</select>';
?>

[akela]

This attechment can also helping.

[marky2coats]

The best way, i have found, to deal with date sorting is to convert all dates into a UNIX time stamp using a combination of mktime() and date().

When you have a timestamp (a really big interger representing the number of seconds past since Jan 1970 i believe?) you can just sort them by value.

Easy.

Mark.

[tekky]

if yo uare pulling the dates from the database, then just ORDER BY 'date_field_name' ASC

or can use DESC to invert the order.... then you get the dates in order straight from the database

[websitealarm]

Maybe this will help too:

<shown in mysql format>

this will get everything from your table, sorted by oldest date first

select * from table_name order by date_field_name

this will get everything sorted by most recent first...

(note the minus sign in front of the order by field name)

select * from table_name order by -date_field_name