Topic awaiting preservation: MySQL Listing Alphabetical |
|
---|---|
Author | Thread |
Bipolar (III) Inmate From: Canada |
posted 02-14-2004 00:26
Ok, I have a website where I post tutorials on. Now I have all my tutorials in SQL with the following table |
Maniac (V) Inmate From: Florida |
posted 02-14-2004 00:52
The ORDER BY clause is alphabetical by default, ASC (ascending) code: SELECT * FROM table ORDER BY title ASC
|
Maniac (V) Inmate From: under the bed |
posted 02-14-2004 01:36
And just to clarify slightly, it's not in the PHP, it's right in your SQL - let the database do the work whenever possible. |
Paranoid (IV) Mad Scientist with Finglongers From: Germany |
posted 02-14-2004 11:09
and read at least the select section in the mysql manual... there are a number of such goodies that the database can handle for you. |