alphabetical order

[stuworx]

how do i query my db to display records in alphabetical order?

[stolzyboy]

$query = "select * from tablename order by fieldname;";
$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{
echo $row['fieldname'] . "<br>";
}