RQ: HELP

[PHPclown]

Hello guys.

I need some help here.
I know its easy i've done it before but i just cant figure it out right now.

How can i put into html tables 3 rows from database without making more than one html table.

I know it is with $i++.. but i forgot the way.

Here is the code:

<?php
$top_players = "SELECT * FROM players ORDER by level LIMIT 5";
$top_players1 = mysql_query($top_players);
$top_players2 = mysql_fetch_array($top_players1);

echo "<strong>TOP 20</strong>";
echo "<table border='1' bgcolor='#85fe23' class='battle_table'>";
echo "<tr></tr>";
echo "<td bgcolor='#f4bd52'><center>Name</center></td>";
echo "<td bgcolor='#f4bd52'><strong><center>Class:</center></strong></td>";
echo "<td bgcolor='#f4bd52'><strong><center>Level:</center></strong></td>";
echo "<td bgcolor='#f4bd52'><strong><center>Attack:</center></strong></td>";
echo "<td bgcolor='#f4bd52'><strong><center>Defense:</center></strong></td>";
echo "<td bgcolor='#f4bd52'><strong><center>Hit points:</center></strong></td>";
echo "</tr>";
echo "<td bgcolor='#e7dfd0'><center>" . $top_players2['name'] . "</center></td><br>";
echo "<td bgcolor='#e7dfd0'><center>" . $top_players2['class'] . "</center></td><br>";
echo "<td bgcolor='#e7dfd0'><center>" . $top_players2['level'] . "</center></td><br>";
echo "<td bgcolor='#e7dfd0'><center>" . $top_players2['attack'] . "</center></td>";
echo "<td bgcolor='#e7dfd0'><center>" . $top_players2['defense'] . "</center></td>";
echo "<td bgcolor='#e7dfd0'><center>" . $top_players2['hpoints'] . "</center></td><br><br><br>";
echo "</tr>";
echo "<tr>";
echo "</tr>";
echo "</table>";

?>

Thank you!

[halojoy]

Yes, it is pretty standard query and fetch result
in one [man]while[/man] loop.

You know it 🙂 when you see it here

<?php

// Get 5 top players
$sql = "SELECT * FROM players ORDER by level LIMIT 5";

$result = mysql_query($sql);
if( mysql_error() ) exit( mysql_error() );

echo "<strong>TOP 20</strong>";
echo "<table border='1' bgcolor='#85fe23' class='battle_table'>";
echo "<tr></tr>";
echo "<tr>";
echo "<td bgcolor='#f4bd52'><center>Name</center></td>";
echo "<td bgcolor='#f4bd52'><strong><center>Class:</center></strong></td>";
echo "<td bgcolor='#f4bd52'><strong><center>Level:</center></strong></td>";
echo "<td bgcolor='#f4bd52'><strong><center>Attack:</center></strong></td>";
echo "<td bgcolor='#f4bd52'><strong><center>Defense:</center></strong></td>";
echo "<td bgcolor='#f4bd52'><strong><center>Hit points:</center></strong></td>";
echo "</tr>";

// Fetch each row from the $result
while( $player = mysql_fetch_array($result) )
{
	echo "<tr>\n";
	echo "<td bgcolor='#e7dfd0'><center>" . $player['name'] . "</center></td><br>";
	echo "<td bgcolor='#e7dfd0'><center>" . $player['class'] . "</center></td><br>";
	echo "<td bgcolor='#e7dfd0'><center>" . $player['level'] . "</center></td><br>";
	echo "<td bgcolor='#e7dfd0'><center>" . $player['attack'] . "</center></td>";
	echo "<td bgcolor='#e7dfd0'><center>" . $player['defense'] . "</center></td>";
	echo "<td bgcolor='#e7dfd0'><center>" . $player['hpoints'] . "</center></td><br><br><br>";
	echo "\n</tr>\n";
}

echo "<tr>";
echo "</tr>";
echo "</table>";

?> 

[PHPclown]

Thank you man!

One more question if possible.

Can you tell me how to attach an url to every single user with this code.
So people can click on every user in the top.

Thank you a lot !

[PHPclown]

And last one to show only 20 per page 😛