[PHP][MySQL]Dane z mysql do tabeli html Opcje

[Owghard]

Witam. Mam pewien problem z mysql, mianowicie muszę zrobić tak aby z bazy było pobieranie rekordów o najwyższym rankingu.

[SQL] pobierz, plaintext 
<!--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-->
[SQL] pobierz, plaintext 

Mam takie coś do pobierania tych danych i teraz muszę je wstawić do tabeli w miejsce tych XXX:

[HTML] pobierz, plaintext 
<!--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-->
[HTML] pobierz, plaintext 

[SQL] pobierz, plaintext 
<!--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-->
[SQL] pobierz, plaintext 

Mógłby ktoś mi powiedzieć jak to zrobić?

Ten post edytował Owghard 7.06.2014, 13:34:31