[PHP] DESC

Beste one2xs .

Op Klikspel.eu heb ik nu problemen bij het ordenen via DESC

zie http://www.klikspel.eu/jtmedia/top100.php
, daar staat alles door elkaar al heb ik via DESC laten ordenen ( order by ... DESC )
ook op de hoofdpagina, de stats onderaan heb ik dit probleem, wie kan mij helpen?

Wouter

Dan zal er toch een fout in je query zitten..

*HINT* Je query zou dus handig zijn..

DESC LIMIT 10

Als je ff de query gaf....

Ligt denk ik aan je DB.

@Frozenflame
Ligt aan de query...

[COLOR= #0000BB]<?
$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"select * from dealer order by leden DESC limit 5"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$object[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_object"]mysql_fetch_object[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700])){[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"<ul class=footer_menu_list><li><a href=http://www.klikspel.eu/$object->naam>$object->naam</a> $object->leden </li></ul>"[/COLOR][COLOR= #007700];
        }[/COLOR]
        ?>

DIt is de verkeerder QUery...

geef dan de juiste

Hij bedoeld dat jij de code van een heel ander iets geeft
Niet van de betreffende pagina..

Dus, geef dan de juiste (aan wouter gericht)

*zucht*, was die van de stats

[COLOR= #0000BB]<?
$rank2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$top2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM `deal_leden` WHERE game = $game ORDER BY saldo DESC LIMIT 100"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$top1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top2[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top1[/COLOR][COLOR= #007700])){[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]1[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#FFD700" size="5">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]2[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#C0C0C0" size="4">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]3[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#B87333" size="3">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]vip[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]yes[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$actief[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="green">Ja</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$actief[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="red">Nee</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$actief[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]saldo[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td><td><a href="http://www.klikspel.eu/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$game[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/klik.php&user=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" target="_blank">Klik</a></td></tr>[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700];
}[/COLOR]
?>

[COLOR= #0000BB]<?
$rank2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$top2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM `deal_leden` WHERE game = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$game[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" ORDER BY saldo DESC LIMIT 100"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$top1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top2[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top1[/COLOR][COLOR= #007700])){[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]1[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#FFD700" size="5">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]2[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#C0C0C0" size="4">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]3[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#B87333" size="3">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]vip[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]yes[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$actief[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="green">Ja</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$actief[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="red">Nee</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$actief[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]saldo[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td><td><a href="http://www.klikspel.eu/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$game[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/klik.php&user=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" target="_blank">Klik</a></td></tr>[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]++;
}[/COLOR]
?>

Eerste fout die ik zosnel zag, kijk maar ff of dit werkt

nope, nog net hetzelfde

Hehe, zet eens saldo op int

Marijnnn, dankjewel !

Hoe komt dit trouwens?