[RESOLVED] place data into html tables

scorpious

Hi All

I am tryin to place data into a html table. It has to be 3 columes long and show the top 10 players.

The headings will be: Player | Kills | Deaths

with the information placed under the heading.

This is what I have so far:

<?php
$username = "username";
$password = "password";
$hostname = "localhost";

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Top 10 Players <br><br>"; // Means Connected to Database

//select a database to work with
$selected = mysql_select_db("battalion",$dbhandle)
or die("Could not select battalion");

//execute the SQL query and return records
$result = mysql_query("SELECT playerID, kills, deaths FROM vsp_playerprofile ORDER BY kills DESC");
echo "Players Name: "."Kills: "."Deaths: "."<br>";
echo "<br>";

//fetch tha data from the database
while ($row = mysql_fetch_array($result)) {

echo $row{'playerID'}." Kills: ".$row{'kills'}.$row{'skill'}." Deaths:".$row{'deaths'}."<br>"."<br>";

}
//close the connection
mysql_close($dbhandle);
?>

I have seen many ways to complete this, but a bit confussing, what would be the best way to complete this ?

Many thanks

Scorp (Newbie to this)

sid

there really arent that many way's to complete this actually. at least not that i can think of.
if you are familiar with html tables, this should be a rather uncomplicated op.

old:

echo "Players Name: "."Kills: "."Deaths: "."<br>";
echo "<br>";

//fetch tha data from the database
while ($row = mysql_fetch_array($result)) {

echo $row{'playerID'}." Kills: ".$row{'kills'}.$row{'skill'}." Deaths:".$row{'deaths'}."<br>"."<br>";

}

new:

echo "<table>
    <tr>
        <td>Players Name</td>
        <td>Kills</td>
        <td>Deaths</td>
    </tr>";

//fetch tha data from the database
while ($row = mysql_fetch_array($result)) {
    echo "
    <tr>
        <td>" . $row['playerID'] . "</td>
        <td>" . $row['kills'] . " " . $row['skill'] . "</td>
        <td>" . $row['deaths'] . "</td>
    </tr>";
}

echo "</table>";

sid

for the top 10 players, change the query to

SELECT playerID, kills, deaths 
FROM vsp_playerprofile 
ORDER BY kills DESC
LIMIT 10;

however - you are not including the 'skills' column in your result set, but using it for the display! probably a "SELECT *" would be more useful for this.

bradgrafelman

sid wrote:
probably a "SELECT " would be more useful for this.

On the contrary, "SELECT " should never be used (okay, if you've nexted a SELECT inside an INSERT query, it might be, but for general use...).

scorpious

Hi All

Many thanks for your fast reply, changed the code to your code and worked first time and the LIMIT did.

Many thanks guys 😃

Scorp

bradgrafelman

Don't forget to mark this thread resolved.

scorpious

Hi All

Sorry to be a pain, but how can I center the above, so its in the middle of the page?

I have tried the <center> command but cant seam to get it to work.

Cheers

Scorp

bradgrafelman

You want the entire table centered? If so, add align="center" to the <table> tag.

scorpious

I have added the align="center" to the <table> tag like the following

echo "<table align="center">

now I get a blank screen lol, what have I done wrong ?

Cheers

Scorp

bradgrafelman

You didn't properly escape the double quotes in the string, since you used double quotes as your string delimiters.

scorpious

:queasy:

It works great, sorry thought I had to leave the double quotes

Slowly but surely I will learn :rolleyes:

Cheers once more

Scorp

sid

bradgrafelman wrote:
On the contrary, "SELECT *" should never be used (okay, if you've nexted a SELECT inside an INSERT query, it might be, but for general use...).

i disagree - it really depends on the size of his table.

laserlight

i disagree - it really depends on the size of his table.

But of course, bubble sort works well for a small enough container.

The way I see it, explicitly listing the columns to be retrieved not only means that less data need be returned, but also gives a better idea of what the query is for. Either way, it is better to know what you are doing than to blindly get everything, and then later come back to fix it when your table has grown in size.