la fonction view est integre depuis la version 5 ( que j'ai pas encore)
mais en m'inspirant fortement de l'exemple de Gyro Gearllose voila une solution:
( la fonction mysdl_fetch_row accept une seul parametre dans ma version)
$req1 = "CREATE TEMPORARY TABLE tmp (equipe decimal(3,2), note decimal(3,2))";
$res1 = mysql_query ($req1);
$req2 = "SELECT DISTINCT equipe FROM $dbtable";
$res2 = mysql_query($req2);
while(list($rSet1)=mysql_fetch_array($res2))
{
$req3 = "INSERT INTO tmp SELECT equipe,note*maj FROM $dbtable WHERE equipe={$rSet1[0]} ORDER BY sol_note DESC LIMIT 3";
$res3 = mysql_query ($req3);
}
$req4 = "SELECT equipe,SUM(note) AS s FROM tmp GROUP BY equipe ORDER BY s DESC";
$res4 = mysql_query ($req4);
[^] # Re: Solution détournée...
Posté par stephane . En réponse au message mysql: selectioner une partie des données. Évalué à 1.
$req1 = "CREATE TEMPORARY TABLE tmp (equipe decimal(3,2), note decimal(3,2))"; $res1 = mysql_query ($req1); $req2 = "SELECT DISTINCT equipe FROM $dbtable"; $res2 = mysql_query($req2); while(list($rSet1)=mysql_fetch_array($res2)) { $req3 = "INSERT INTO tmp SELECT equipe,note*maj FROM $dbtable WHERE equipe={$rSet1[0]} ORDER BY sol_note DESC LIMIT 3"; $res3 = mysql_query ($req3); } $req4 = "SELECT equipe,SUM(note) AS s FROM tmp GROUP BY equipe ORDER BY s DESC"; $res4 = mysql_query ($req4);voila mission accomplie , merci a vous