How to use ORDERY BY ASC?

phpsql_me

Hello.

I have a script that echoes out usernames to screen, but I'd like to Order them by ASCending order so they come out in alphabetical order.

Heres my code, can someone let me know where I input the ORDERY BY command?

while ($result = mysql_fetch_array($q)) { echo('<a href="http://www.website.com/edit_user.php?logon_username=' . $result['logon_username']  . '">' . $result['logon_username'] . '</a><br>'); }

bretticus

The syntax is fairly simple:

SELECT * FROM usernames ORDER BY logon_username

Dvector

You could also do:

SELECT * FROM usernames ORDER BY logon_username ASC

Should get you the same result as bretticus, but this way you know it is ascending when looking at the code.

Likewise you could do:

SELECT * FROM usernames ORDER BY logon_username DESC

which would get you the opposite ordering.