December 20th, 1999, 10:41 PM
-
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
December 21st, 1999, 04:35 AM
-
SELECT * FROM $state WHERE City = '$cities' ORDER BY City ASC [or DESC]
Merry Christmas and happy 2000 to all of you too!