Solved Frags page

[Aleada]

Heya everyone, I'm trying to make a frags page for my website but it's only showing 1 player (The player with the most frags) it's not showing more than 1 :/ it's probably something really simple but I can't seem to figure it out :/ Anyways... here's the scripts:

<?php require_once 'engine/init.php'; include 'layout/overall/header.php'; ?> 
<h2>Top PVP Players</h2> 
<?php
$getfrags = mysql_query("SELECT `frags`, `level`, `name` FROM `players` ORDER BY `frags` DESC");
$fetchfrags = mysql_fetch_assoc($getfrags);
$frags = $fetchfrags['frags'];
	echo '<table border="0"> 
	<tr class="yellow"><td>Player</td><td>Level</td><td>Frags</td></tr>'; 
    echo '<tr><td>'; 
    echo '<a href="characterprofile.php?name='.$fetchfrags['name'].'">'.$fetchfrags['name'].'</a>';
    echo '</td><td>'; 
    echo $fetchfrags['level']; 
    echo '</td><td>'; 
    echo $frags;
    echo '</td></tr>';
	echo '</table>'; 
?>
<?php include 'layout/overall/footer.php'; ?>

Btw I'm using Znote AAC!

 

[Amino12]

Try this:

<?php require_once 'engine/init.php'; include 'layout/overall/header.php'; ?>  
<h2>Top PVP Players</h2>  
<?php 
$getfrags = mysql_query("SELECT `frags`, `level`, `name` FROM `players` ORDER BY `frags` DESC"); 
$fetchfrags = mysql_fetch_assoc($getfrags);
foreach($fetchfrags as $frags)
{
    echo '<table border="0">  
    <tr class="yellow"><td>Player</td><td>Level</td><td>Frags</td></tr>';  
    echo '<tr><td>';  
    echo '<a href="characterprofile.php?name='.$frags['name'].'">'.$frags['name'].'</a>'; 
    echo '</td><td>';  
    echo $frags['level'];  
    echo '</td><td>';  
    echo $frags['frags'];
    echo '</td></tr>';
    echo '</table>';
}
?> 
<?php include 'layout/overall/footer.php'; ?>

 

[Aleada]

Ermm well that made like 3 tables haha and it is like:

Top PVP Players

Player Level Frags
6 6 6
Player Level Frags
1 1 1
Player Level Frags
F F F

 

[Ninja]

http://otland.net/f118/0-3-6-0-4-to...database-query-68893/index10.html#post1876329

 

[Aleada]

Doesn't work with the table I'm trying to use though :/ That's why I tried to make my own but it didn't work out too well xD

 

[Ninja]

Just edit the query from Znote's post

$killers = mysql_select_multi("SELECT `frags`, `name`, `level` FROM `players` WHERE `frags` > 0 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0,30;");

 

[Aleada]

I didn't think that would work lmfao thank you so much Ninja! And also, thank you Amino12 for trying! Rep to both of you!