[resolved] Ordering SQL selects by multiple cols
Posted: Fri Jul 28, 2006 4:58 pm
Hi,
I was wondering if there was a way to select the data out of my database and order it by multiple fields. For example:
So... am I right or is this not the way to do it?
Thanks,
- Jeff
I was wondering if there was a way to select the data out of my database and order it by multiple fields. For example:
Code: Select all
SELECT * FROM $table_name WHERE id=$idnum ORDER BY year AND month AND dayThanks,
- Jeff