mySQL sort

[jamesloi]

Hi

is there anyway to sort a database into alphabetical order using a field called 'name' ?

thanks

[sgoku01]

I thought it was something like this:

$query = mysql_query("SELECT * FROM name ORDER BY name asc");
while($result = mysql_fetch_array($query)) {
echo $result['name']; 
}