PHP MYSQL order by day and month...HELP please..

Question

Hi i have my mysql

$query = mysql_query('SELECT * from rbf_edades_news order by month DESC '.$limit.'');

month and day are in different fields,

any idea?"

is this possible

$query = mysql_query('SELECT * from rbf_edades_news order by month and DESC '.$limit.'');

Thanks!

Answer 1

This will sort first by month and then by day:

$query = mysql_query('SELECT * from rbf_edades_news order by month DESC, day DESC '.$limit.'');

Answer 2

you can order by 2 columns like

$query = mysql_query('SELECT * from rbf_edades_news order by month DESC, day  DESC '.$limit.'');

Answer 3

You can use order by with 2 field. This should work:

$query = mysql_query('SELECT * from rbf_edades_news order by month, day DESC '.$limit.'');

Answer 4

Hi,

No, your second query is not possible. DESC has to be next to a fieldname like in your first example and it is used to order your results by month in descending order. Use ASC for ascending order.

If you want to order by day and month, you can do the following:

SELECT * from rbf_edades_news order by day DESC, month DESC

One question, what is exactly the content of the $limit variable?