ORDER BY in wrong query!?

[jmansa]

Can't figure this out. I have loop query where inside this loop I have another... In the second loop query I have the ORDER BY sumpoints, but it do not order here... How do I get this ORDER BY into the first query?

echo '<table cellpadding="0" cellspacing="1">
					<tr>
						<td width="20" align="center" valign="middle" bgcolor="#6D84B4"><div style="padding:3px;color:#FFFFFF;">P</div></td>
						<td width="150" align="left" valign="middle" bgcolor="#6D84B4"><div style="padding:3px;color:#FFFFFF;">Player</div></td>
						<td width="50" align="center" valign="middle" bgcolor="#6D84B4"><div style="padding:3px;color:#FFFFFF;">Points</div></td>
					</tr>';

		$sql="SELECT * FROM ".$prefix."_club_users 
				INNER JOIN ".$prefix."_users ON ".$prefix."_club_users.new_userid = ".$prefix."_users.new_userid
				WHERE clubid='$clubid'";
		$result = mysql_query($sql);

		$x = 0; 
		$i = 0; 
		$prev = 0;
		$r_count = 0;

		while($row = mysql_fetch_array($result)){

			$clubuser = $row['new_userid'];
			$fname = $row['fname'];
				$lname = $row['lname'];

			$sql2="SELECT SUM(point) AS sumpoints FROM ".$prefix."_club_leaderboard WHERE seasonid=$seasonid AND userid=$clubuser ORDER BY sumpoints DESC";
			$result2 = mysql_query($sql2);

			while($row2 = mysql_fetch_array($result2)){ 

				$curr = $row2['sumpoints']; 
				if ($curr != $prev) 
				{ 
					$i = $x + 1; 
				} 




				 echo '<tr style="background-color:#' .((++$r_count %2 == 0) ? 'FFFFFF' : 'EEEEEE'). '">';
				 echo '<td width="" align="center" valign="middle"><input name="placement[]" type="text" readonly="true" value="'.$i.'" style="font-size:11px;width:16px;text-align:center;border:none;background-color:transparent;font-family:lucida grande,tahoma,verdana,arial,sans-serif;"/></td>';
				 echo '<td width="" align="left" valign="middle">&nbsp;'.$fname.' '.$lname.'</td>';
				 echo '<td width="" align="center" valign="middle">' . number_format($row2['sumpoints'], 2) . '</td>';
				 echo '</tr>';

				$prev = $curr; 
				$x++; 

			} 
		}
		echo '</table>';

Thanks alot!

[jmansa]

Got it work with this:

$sql = "SELECT u.fname, u.lname, user_points.points FROM ".$prefix."_club_users cu 
						INNER JOIN ".$prefix."_users u ON u.new_userid = cu.new_userid 
						INNER JOIN ( SELECT SUM(point) points, userid FROM ".$prefix."_club_leaderboard 
						WHERE seasonid = $seasonid 
						GROUP BY userid ) user_points ON cu.new_userid = user_points.userid 
						WHERE cu.clubid = '$clubid' ORDER BY user_points.points DESC";