Awjvail
12-06-2007, 11:39 AM
SELECT title, pagecount, createdat, userfriendlyname FROM $WT_DB_TemplateTable
WHERE category = 7
ORDER BY createdat DESC
Right now, my output is in order of creation (fairly sure it is backwards too), however I would like to change "ORDER BY createdat" to make it so that it orders it in alphabetical order.
How would I do this?
WHERE category = 7
ORDER BY createdat DESC
Right now, my output is in order of creation (fairly sure it is backwards too), however I would like to change "ORDER BY createdat" to make it so that it orders it in alphabetical order.
How would I do this?