Display Mysql Info Alphabetically?

[Drewdle]

I have a 'user' table and a display users page.

 

How would I display them in alphabetical order by their username?

 

Heres my current basic display page:

<?php
include 'dbwire.php'; 
include 'header.php';
$query = mysql_query('SELECT * FROM user');

while ($row = mysql_fetch_array($query)) {  
       echo '<b>Username:</b> ' . $row['user'] . '<br />';
       echo '<b>Real Name:</b> ' . $row['name'] . '<br />';
       echo '<b>Email:</b> ' . $row['email'] . '<br />';
       echo '<b>Location:</b> ' . $row['location'] . '<br /> <hr>';
}
?>

 

Theres also an id row but since user wouldn't be added alphabetically I wouldn't be able to order them by id.

[litebearer]

ORDER BY

http://www.tizag.com/mysqlTutorial/mysqlorderby.php

[necken18]

$query = mysql_query('SELECT * FROM user ORDER BY user ASC');