sort in multi array

frenchy373

Hello
I want to display a sql result with a specific order (desc of sum(occur)) but I can't do it with sql ORDER BY because it is a sum

my code is :
<?php
mysql_connect("$sql_serveur","$sql_user","$sql_passwd");
$select_base=@mysql_selectdb("$sql_bdd");
$sql = ($sources_code==0) ? "SELECT DISTINCT(nom),sum(occur) occur FROM noms_propres GROUP BY nom" : "SELECT DISTINCT(nom),occur FROM noms_propres WHERE sources_code=$sources_code GROUP BY nom";
$i=0;
$req = mysql_query($sql);
while ($res = mysql_fetch_array($req))
{
$data[$i][0]=$res[0];
$data[$i][1]=$res[1];
$i++;
}
$nb_mots=10;
echo " <TABLE width=\"100%\" BORDER CELLSPACING=1 CELLPADDING=4>";
echo "<TR>";
echo "<TD WIDTH=\"5%\" VALIGN=\"TOP\">Occ.</TD>";
echo "<TD WIDTH=\"64%\" VALIGN=\"TOP\">Noms Propres</TD>";
echo "<TD WIDTH=\"12%\" VALIGN=\"TOP\"> </TD>";
echo "<TD WIDTH=\"12%\" VALIGN=\"TOP\"> </TD>";
echo "</TR>";
for ($i=0;$i<$nb_mots;$i++)
{
echo "<TR>";
echo "<TD WIDTH=\"5%\" VALIGN=\"TOP\">".$data[$i][1]."</TD>";
echo "<TD WIDTH=\"64%\" VALIGN=\"TOP\">".$data[$i][0]."</TD>";
echo "<TD WIDTH=\"12%\" VALIGN=\"TOP\"> </TD>";
echo "<TD WIDTH=\"12%\" VALIGN=\"TOP\"> </TD>";
echo "</TR>";
}
?>

than you for your help

BeastRider

I don't understand your question. Are you trying to sum multiple columns from a single row, or create a SUM of a column for all the returned results?

SUM returns a single result.