[php] Rankings Something I made for my MapleStory server

[Antv912 0]

<?php$con = mysql_connect("localhost","root","");if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_select_db("maplestory", $con);$result = mysql_query("SELECT * FROM Characters ORDER BY Level DESC");echo "<table border='1'><tr><th>Name</th><th>Level</th><th>Exp</th></tr>";while($row = mysql_fetch_array($result))  {  echo "<tr>";  echo "<td>" . $row['name'] . "</td>";  echo "<td>" . $row['level'] . "</td>";  echo "<td>" . $row['exp'] . "</td>";  echo "</tr>";  }echo "</table>";mysql_close($con);?>

So easy even a Caveman could do it!

$con = mysql_connect("localhost","root","");Host,Username,Password

echo "<td>" . $row['name'] . "</td>";  echo "<td>" . $row['level'] . "</td>";  echo "<td>" . $row['exp'] . "</td>";

$row['xxx']

- Is a row the script echo's from the database

And must match this :

<th>Name</th><th>Level</th><th>Exp</th>

Example

<th>1</th><th>2</th><th>3</th>

This must be ..

echo "<td>" . $row['1'] . "</td>";   echo "<td>" . $row['2'] . "</td>";   echo "<td>" . $row['3'] . "</td>";

You can save this file as Rankings.php
Edited January 26, 2009 by Antv912 (see edit history)