A to Z Date Field?

russellbcv

I am extracting data from table in MySQL but my dates are resulting in no particular order.

Is there a way I can extract the information whereby the date field is ordered i.e from the 1st to the 31st of the month.

This is my code>

$list = "<table class=\"tblist\" border=\"0\" cellpadding=\"5\">";
$list .= "<tr><th>Cli</th>";
$list .= "<th>Date</th>";
$list .= "<th>Time</th>";
$list .= "<th>Dialled</th>";
$list .= "<th>Mins</th>";
$list .= "<th>Cost</th></tr>";
$total_mins = 0;
$total_cost = 0;
while( $row = mysql_fetch_array( $rs ) )
{
$total_mins += $row['mins'];
$total_cost += $row['cost'];
$list .= "<tr>";
$list .= "<td>".$row["cli"]."</td>";
$list .= "<td>".$row["date"]."</td>";
$list .= "<td>".$row["time"]."</td>";
$list .= "<td>".$row["dialled"]."</td>";
$list .= "<td>".$row["mins"]."</td>";
$list .= "<td>".$row["cost"]."</td>";
$list .= "</tr>";
$list .= "</tr>";
}
$list .= "</table>";

russellbcv

date ('j-m-y');

I have just checked php.net and they have used the above date code.

How would I incorporate this within my code?

travelbuff

You need an ORDER BY in your MySql SELECT statement.

$query = "SELECT stuff FROM table ORDER BY order_date ASC";

http://www.developerfusion.com/show/3998/7/