[SOLVED] Ordering results question

[affordit]

Is there a way to order the results from this query?

 

$query_content= "SELECT `heading`, `picture`, `description` FROM `content`";
$result=mysql_query($query_content) or die(mysql_error());

while ($info = mysql_fetch_array($result)) {
echo $info['heading'];
echo "<BR>";
echo $info['image'];
echo "<BR>";
echo $info['description'];
echo"<BR>";
}

[trq]

You can use sql's ORDER BY directive to order alphabetically. Say by the heading field....

 

$query_content= "SELECT heading, picture, description FROM content ORDER BY heading";

 

ps: No need for all the `backticks` either.

[affordit]

Thanks thorpe and thanks for the heads up on the back ticks deal.