SELECT and order by two variables.

[cdherold]

I'm trying to order a query by two keys. For instance ... the first key is percent relevance (percent_rel), the second key is date_submitted. In any group of selections there will be many that have the same percent_rel, when there is I want those within that group ordered by date.

Right now my statement is:
"SELECT * from search ORDER BY percent_rel DESC LIMIT 0,49";

What do I say to get it to have this second level of ordering where it orders by most recent date submitted?

For output something like:
100% Jan 15, 2002
100% Jan 4, 2002
100% Dec 23, 2002
75% Jan 26, 2002
56% Feb 12, 2002

thanks,

cdherold

[[deleted]]

just add the second field in the order clause:

ORDER BY percent_rel, date_field

Tip: read some docs about SQL syntax, they are all over the place and very helpfull.

[cdherold]

I had tried that and it gave me a MySQL error. Had also tried other random stuff like ORDER by and ORDER by. Had looked at MySQL documentation for SELECT and did not see anything that addressed this issue, though could have missed it. Will check again.

thanks,

cdherold