Arrangere i alfabetisk orden fra mysql
jeg har lidt kode her som jeg gerne ville have arrangeret i alfabetisk orden fra $row[fornavn] med start i a,b,c osv.<?
session_start();
echo \"<body bgcolor=\'#47525F\' link=\'#CCCCCC\' vlink=\'#CCCCCC\' alink=\'#CCCCCC\'><BR><center><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'>Dine kontakter.....</font></center>\";
mysql_connect(\"localhost\",\"djsaw\",\"pipsyl\");
mysql_select_db(\"djsaw\");
$sql = \"SELECT nick FROM bruger WHERE nick=\'$brugernavn\'\";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
if ($row){
if ($brugernavn){
mysql_connect(\"localhost\",\"djsaw\",\"pipsyl\");
mysql_select_db(\"djsaw\");$result = mysql_query(\"select * from kontakt WHERE nick=\'$brugernavn\'\");
while ($row = mysql_fetch_array($result))
echo \"
<BR>
<table width=\'100%\' border=\'0\'>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Fornavn:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[fornavn]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Efternavn:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[efternavn]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Adresse:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[adresse]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Nummer:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[nummer]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Postnummer:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[postnummer]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>By:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[byen]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Email:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[email]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Mobil:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[mobil]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Telefon:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[tlf]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Icq:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[icq]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Land:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[land]</b></font></td>
</tr>
<tr>
<td width=\'50%\'>
<div align=\'right\'><b><font face=\'tahoma\' color=\'#999999\' size=\'4\'>Beskrivelse:</font></b></div>
</td>
<td width=\'4%\'> </td>
<td width=\'46%\'><font face=\'tahoma\' color=\'#c9c9c9\' size=\'4\'><b>$row[beskrivelse]
</b></font></td>
</tr>
</table>
