Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[bluman2008]

Cod:
$back = 0;
$i = 0;
$cerereSQL = 'SELECT * FROM `formular` ORDER BY `iid`';
$rezultat = mysql_query($cerereSQL);
while($rand = mysql_fetch_array($rezultat)) {
if ( $back != $rand['iid'] ) {
        $i=$i+1;
   $count=0;
        $csql= "SELECT * FROM `formular` WHERE `iid` = '".$rand['iid']."'";
   $rz=mysql_query($csql);
   while(mysql_fetch_array($rz)) {
   $count=$count+1;
        }
        $loc[$i] = $count;
        $nm[$i] = $rand['iid'];
}
$back = $rand['iid'];
}
for ( $c = 1; $c <= $i-1; $c += 1) {
for ( $d = c+1; $d <= $i; $d += 1) {
if ( $loc[$c] > $loc[$d] ) {
$b1 = $loc[$c];
$b2 = $nm[$c];
$loc[$c] = $loc[$d];
$nm[$c] = $nm[$d];
$loc[$d] = $b1;
$nm[$d] = $b2;
}
}
}
for ( $l = 0; $l <= 10; $l += 1) {
echo $nm[$l];
echo $loc[$l];
}

In coloana iid din tabelul formular am mai multe nume care se repeta.
Vreau sa vad de cate ori se repeta ca sa fac un top.
Imi afiseaza doar 3 dintre cele 4 usere care le am si nu am idee de ce .

[dechim]

Te-ai complicat, interogheaza asa :
$cerereSQL = 'SELECT iid, count(iid) as count FROM formular GROUP BY iid ORDER BY count DESC; ';
si-ti rezulta direct top-ul

[PHPRomania Bot]