Dev Shed Forums

I have forgotten how to list my results alphabetically... Can someone refresh my memory... Please...

example:

$result = mysql_query("SELECT * FROM $state WHERE City = '$cities'",$db);

$count = mysql_num_rows($result);

$today = getdate();

$month = $today[month];

$day = $today[mday];

$year = $today[year];

if ($myrow = mysql_fetch_array($result)) {

.... blah, blah, blah...


Thank you so much and have a great Christmas

SELECT * FROM $state WHERE City = '$cities' ORDER BY City ASC [or DESC]

Merry Christmas and happy 2000 to all of you too!