Fetching and Sorting Data

[Anon]

I have a mysql table with 2 fields
Name
Address

How would I use MySQL to fetch the data and output them in alphabetical order by the Name?

Thanks in advance..=)

[mrblom]

$query = "SELECT * FROM table ORDER BY name";

$connection = mysql_connect($dbhost, $dbusername, $dbpassword)
mysql_select_db($dbdatabase, $connection);

$result = mysql_query($query);

while( $row = mysql_fetch_array($result)){

print "$row[\"Name\"] $row[\"Address\"]";

}

This should do...

Kristian