Witam. Mam pewien problem z mysql, mianowicie muszę zrobić tak aby z bazy było pobieranie rekordów o najwyższym rankingu.
<!--c1--><div class='codetop'>Kod</div><div class='codemain'><!--ec1-->mysql_select_db("guilds");
$wyniki = mysql_query("SELECT * FROM gracze ORDER BY ranking DESC LIMIT 10");<!--c2--></div><!--ec2-->
Mam takie coś do pobierania tych danych i teraz muszę je wstawić do tabeli w miejsce tych XXX:
<!--c1--><div class='codetop'>Kod
</div><div class='codemain'><!--ec1--><tr><td class="tg-0"><img src="https://minotar.net/helm/XXX"</td><td class="tg-1"><a href=playerXXX.html?id=2267>1. XXX
</td><td class="tg-2">1000
</td></tr> <tr><td class="tg-0"><img src="https://minotar.net/helm/XXX"</td><td class="tg-1"><a href=playerXXX.html?id=2266>2. XXX
</td><td class="tg-2">1000
</td></tr> <tr><td class="tg-0"><img src="https://minotar.net/helm/XXX"</td><td class="tg-1"><a href=playerXXX.html?id=2265>3. XXX
</td><td class="tg-2">1000
</td></tr> <tr><td class="tg-0"><img src="https://minotar.net/helm/XXX"</td><td class="tg-1"><a href=playerXXX.html?id=2263>4. XXX
</td><td class="tg-2">1000
</td></tr> <tr><td class="tg-0"><img src="https://minotar.net/helm/XXX"</td><td class="tg-1"><a href=playerXXX.html?id=2261>5. XXX
</td><td class="tg-2">1000
</td></tr> <tr><td class="tg-0"><img src="https://minotar.net/helm/XXX"</td><td class="tg-1"><a href=playerXXX.html?id=2257>6. XXX
</td><td class="tg-2">1000
</td></tr> <tr><td class="tg-0"><img src="https://minotar.net/helm/XXX"</td><td class="tg-1"><a href=playerXXX.html?id=2255>7. XXX
</td><td class="tg-2">1000
</td></tr> <tr><td class="tg-0"><img src="https://minotar.net/helm/XXX"</td><td class="tg-1"><a href=playerXXX.html?id=2253>8. XXX
</td><td class="tg-2">1000
</td></tr> <tr><td class="tg-0"><img src="https://minotar.net/helm/XXX"</td><td class="tg-1"><a href=playerXXX.html?id=2242>9. XXX
</td><td class="tg-2">1000
</td></tr> <tr><td class="tg-0"><img src="https://minotar.net/helm/XXX"</td><td class="tg-1"><a href=playerXXX.html?id=2235>10. XXX
</td><td class="tg-2">1000
</td></tr><!--c2--></div><!--ec2-->
<!--c1--><div class='codetop'>Kod</div><div class='codemain'><!--ec1-->--
-- Zrzut danych tabeli `gracze`
--
INSERT INTO `gracze` (`graczID`, `nick`, `ranking`) VALUES
(1, 'XXX', 995),
(2, 'XXX', 871),
(3, 'XXX', 783),
(4, 'XXX', 783),
(5, 'XXX', 871);
-- --------------------------------------------------------<!--c2--></div><!--ec2-->
Mógłby ktoś mi powiedzieć jak to zrobić?