MySQL "ORDER BY" Query
 

[sql]SELECT title, pagecount, createdat, userfriendlyname FROM $WT_DB_TemplateTable
WHERE category = 7
ORDER BY createdat DESC[/sql]

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?

ORDER BY title.

Thanks.

Now, how would I reverse the order of them? right now they're going from Z to A.

Sorry. :)

ORDER BY title ASC

Perfect.

Thanks so much.