Fragers.php Problem For TFS 1.0

[CesarZ]

I have this error comming from my php

This is the php.

<?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'; ?>

I went to my phpmyadmin and check my players SQL to see if it has a "frag" base and it doesn't. I think that the fragers.php has to pick up a "frag" numbers from the player section in order to work.

Now... if i add the frag bar in players section would the server be able to provide me with numbers of frags once a players start killling other players, or do I have to make a lua so it can send each player frag to that "frag" section in MYSQL?

If i just have to add the frag send me the SQL Query please!
Thanks for your help.

 

[Fifflaren]

@Ricarpe is your man for websites.

 

[CesarZ]

Problem fixed