PHP and mysql leaderboard wont display information

Question

I am trying to display mysql data in a table except nothing is being display.

<?php
                    $query = $koneksi->prepare("SELECT name,kill,death from `player`");
                    $query->execute();
                    if($query->rowCount() == 0)
                    {

Here I am getting the data

    {
                        echo "<tr><td colspan='6'><small>There's no player on ban list</small></td></tr>";
                    }
                    while($data = $query->fetch())
                    {
                        echo "<tr><td>".$data['name']."</td>";
                        echo "<td>".$data['kill']."</td>";
                        echo "<td>".$data['death']."</td>";
                        $kd = $data['kill'] / $data['death'];
                        echo "<td>".$kd."</td></tr>";
                    }
                    ?>

Now I am displaying the data except nothing shows.

Do you see any error messages? If you dont then did you configure PHP to show you error messages? — Salman A, Jul 02 '15 at 19:13

score 1 · Answer 1 · edited Jul 02 '15 at 19:14

1

kill is a reserved word. Try to surround it by backticks like `kill`

edited Jul 02 '15 at 19:14

Salman A

262,204
82
430
521

answered Jul 02 '15 at 19:12

Jehad Keriaki

545
5
10

PHP and mysql leaderboard wont display information

1 Answers1