How do I order the results of my query?

To order the results, use the ORDER BY wording.

So if you have a list of first names, you will often want to order them alphabetically and not in the jumbled format that they come out of the database. So here's how to do it:


<?php

$atozofnames = mysql_query("SELECT firstname FROM names ORDER BY firstname");

?>

Comment on this Question and Answer >>>

ASK A QUESTION

How do I order the results of my query?

More mysql PHP Questions