How to set alpha order in data
<p>HI i get the  data but not in  alphabtical order  here is my code</p>

<pre><code>$result=mysql_query($query);
if($result)
{
$row=mysql_fetch_row($result);
$message=array("realname"=&gt;$row[0],"currentsongid"=&gt;$row[1],"currentsonglistid"=&gt;$row[2],"songlistname"=&gt;$row[3],"songtitle"=&gt;$row[4],"songartist"=&gt;$row[5]);

}
else
{
$message=array("message"=&gt;"error in code");
}
echo json_encode($message);
}
</code></pre>

<p>plz tell me how to arrange data in alphabtical order</p>
