Sort Order? Please Help!

[Prince]

Can someone tell me how to make this sort by artid# (currently it does not sort or order them at all)

OpenTable(); 
$result2 = sql_query("select image from ".$prefix."_sections where secid=$secid", $dbi); 
list($image) = sql_fetch_row($result2, $dbi); 
echo "<center><img src=\"images/sections/$image\" border=\"0\" alt=\"\"><br><br> 
<font class=\"boxtitle\"> 
"._THISISSEC." <b>$secname</b></font><br><br> <font class=\"boxcontent\">"._FOLLOWINGART."</font></center><br><br> 
<table border=\"0\" align=\"center\">"; 
while (list($artid, $secid, $title, $content, $counter) = sql_fetch_row($result, $dbi)) { 
echo " 
<tr><td align=\"left\" nowrap><font class=\"content\"> 
<li><a href=\"modules.php?name=Sections&op=viewarticle&artid=$artid\">$title</a> ($counter "._READS.") 
<a href=\"modules.php?name=Sections&op=printpage&artid=$artid\"><img src=\"images/print.gif\" border=\"0\" Alt=\""._PRINTER."\" width=\"15\" height=\"11\"></a> 
</td></tr> 
"; 
} 
echo "</table><br><br>"; 
CloseTable();

[Lars_Berg]

Rows in a relational database are not ordered. To get an ordered result you must use an order by clause.

$result2 = sql_query("select image from ".$prefix."_sections where secid=$secid order by artid#", $dbi);