Tidus
08-03-2002, 11:55 AM
Hello.
I would like to know how to order something alphabetically.
I have made a database with lyrics - song titles and words. And I have made it so the page lists all the songs that are there, but i would like to know how to sort the alphabetically.
Here is a sample of the code!
// show lyrics list
$result = mysql_query("SELECT * FROM lyrics ORDER BY title ??? ",$db);
if ($myrow = mysql_fetch_array($result)) {
Thank you very much!
I would like to know how to order something alphabetically.
I have made a database with lyrics - song titles and words. And I have made it so the page lists all the songs that are there, but i would like to know how to sort the alphabetically.
Here is a sample of the code!
// show lyrics list
$result = mysql_query("SELECT * FROM lyrics ORDER BY title ??? ",$db);
if ($myrow = mysql_fetch_array($result)) {
Thank you very much!