Order by date

[web_master]

Hi,

 

<?php 
$QueryReturn = mysql_query('SELECT
	`ra_progbyday_year`,
	`ra_progbyday_month`,
	`ra_progbyday_day`
FROM
	`ra_progbyday`
ORDER BY
	??? ASC
');

?>

 

I got this query. `ra_progbyday_year`, `ra_progbyday_month` and `ra_progbyday_day` is an INT which is after reload for example: `ra_progbyday_year` = 2009, `ra_progbyday_month` = 04 and `ra_progbyday_day` = 04.

 

I got problem after ORDER BY, because I want to "ORDER" by date after reload. How can I list this 3 params like "date"?

 

- Or its enough to create column: `ra_progbyday_date` looks like: 20090404

 

Always will have a earlier date smaller nr that later date?

 

thnanx

T

 

 

[charleshill]

You can use a timestamp column to order things by their date. You can also order them using their month and year columns...

 

ORDER BY year DESC, month DESC

 

Haven't ever done it, but I'd imagine you can use any number of columns to order the data with... So try ORDER BY year DESC, month DESC, day DESC too if you want.

[revraz]

If you would store the date correctly, you wouldn't have this problem.

[web_master]

If you would store the date correctly, you wouldn't have this problem.

 

Thanx!

[fenway]

- Or its enough to create column: `ra_progbyday_date` looks like: 20090404

Like revraz said, make a proper date column.  In the meanwhile, an "ORDER BY CONCAT_WS( '-', ra_progbyday_year, ra_progbyday_month, ra_progbyday_day) DESC" will work.