alphabetizing results

[[deleted]]

ok, i did a search through the forums and did not find anything pertinent...

does anyone know how to select from a mysql database and post the results in alphabetical order?

i need to select two columns from my simple 'guestbook' database and post the results in alphabetical order.

the fields selected from the database will be name and email, and i want to alphabetize by name...

thanks for any tips!

[guzmanelbueno]$
:wq

[Anon]

If I'm following you right, you just need an SQL statement:

$sql = "SELECT tblGuestBook.Name, tblGuestBook.Email FROM tblGuestBook
ORDER BY tblGuestBook.Name";

$sqlresults=mysql_query($sql)
or die(mysql_error());

while($row=mysql_fetch_array($sqlresults))
{
$GuestName=$row["Name"];
$GuestEmail=$row["Email"];

echo "$GuestName<br>$GuestEmail<br>";

}

Instead of the echo, you would probably want to throw it into a table and jazz it up.