[mysq] źle sortuje rekordy Opcje

[Zmorcia]

Witam mam takie zapytanie

[PHP] pobierz, plaintext 
<?
 
$query = mysql_query("SELECT * FROM ".PREFIKS."users WHERE user_name IN (SELECT `reply_user` FROM `".PREFIKS."complete`) ORDER BY");
 
while($row = mysql_fetch_array($query)){
    $userComplete = mysql_num_rows(mysql_query("SELECT * FROM ".PREFIKS."complete WHERE reply_user='".$row['user_name']."'"));
    echo $row['user_name'].' ['.$userComplete .']<br />';
}
?>
[PHP] pobierz, plaintext 

I wynikiem tego mam to:

Kod

Qba [16]
test [1]
Kostka [9]

a chce aby posegregowało mi wg. największej ilośći punków:

Kod

Qba [16]
Kostka [9]
test [1]

Za pomoc dam plusa (IMG:http://forum.php.pl/style_emoticons/default/smile.gif)

[kefirek]

Albo zobacz może tak

[PHP] pobierz, plaintext 
<?php
$query = mysql_query("SELECT * FROM ".PREFIKS."users WHERE user_name IN (SELECT `reply_user` FROM `".PREFIKS."complete`)");
 
while($row = mysql_fetch_array($query)){
   $userComplete = mysql_query("SELECT *, COUNT(user_name) AS ile 
   FROM ".PREFIKS."complete WHERE reply_user='".$row['user_name']."' GROUP BY user_name ORDER BY ile DESC");
while($row1 = mysql_fetch_array($userComplete)){   
   
echo $row1['user_name']." [".$row1['ile']."]<br />";
}
}
?>
[PHP] pobierz, plaintext 

Ten post edytował kefirek 10.01.2009, 13:08:49