Help with Rankings

08/04/2009 01:42 killermickle#1
Hey, im using rankings made by scott something. I didnt make any of this.
Im trying to insert the rank itself into the left hand column, I have no idea how though. Tried closing tds & trs but didnt work.
I echod one of the row variables which just appears as the data all written as one thing without spaces

Code:
$sql = "SELECT
                c.Level as Level,
                c.CharName as CharName,
                c.Job as Job
                FROM
                characters as c
              ORDER BY
                c.Level
              DESC
              LIMIT 0,10
              ";
$result = @mysql_query($sql) or die(mysql_error());

echo "<table border='0' style='border-collapse: collapse'><div align='center'>";
echo "<tr><th width='30'>Rank</th><th width='100'>Level``	</th> <th>Name</th> <th>Class</th> </tr>";

while($row = mysql_fetch_array( $result )) {
	echo "<tr><td bgcolor=''>"; 
        echo "1 - 10 rankings here D:";
	echo "</td><td bgcolor=''>"; 
	echo $row['Level'];
	echo "</td><td bgcolor=''>"; 
	echo $row['CharName'];
	echo "</td><td bgcolor=''>";
	include ('class.php');
	echo "</td></tr>"; 
} 
				echo "</div></table>";