Simple PHP, MySQL

[dean7]

Hey all, I've coded an online script for my website which works perfectly although when it shows whos online I'm wanting it to order the usernames in alphabetical order, I have this so far:

 

$select = mysql_query("SELECT * FROM $TblUsersInfo WHERE online > '$timenow' ORDER BY 'username' ASC") or trigger_error ("Error on line " . __LINE__ . mysql_error());
while ($i = mysql_fetch_object($select)){

echo "<a onmouseover=\"ddrivetip('<u><b>$i->username Stats</b></u>:<br /><code>> Username</code>: $i->username <code><</code><br /><code>> Rank</code>: $i->rank <code><</code><br /><code>> Location</code>: $i->location <code><</code><br /><code>> Crew</code>: $crew <code><</code><br /><code>> Userlevel</code>: $userlevel <code><</code>');\" onMouseout=\"hideddrivetip()\" href='profile.php?username=$i->username'>$echo</a> : ";
}

 

But what I've got there it is ordering by the ID even though I've got ORDER BY 'username' in the Query, how would I change it so its in alphabetical order?

 

Thanks for any help

[AbraCadaver]

You don't quote column names just string literals.  Use either just username or use backticks not quotes `username`.

[the182guy]

MySQL will take ORDER BY 'username' as a string literal, not a field name and that is why it's producing unexpected [to you] results. As AbraCadaver said use backticks or nothing at all for field names.