Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //Again, fill in your server data here!
- $host="localhost"; // Host name
- $username="----"; // Mysql username
- $password="----"; // Mysql password
- $db_name="----"; // Database name
- $tbl_name="---"; // Table name
- // Connect to server and select database.
- mysql_connect("$host", "$username", "$password")or die("cannot connect");
- mysql_select_db("$db_name")or die("cannot select DB");
- //This query grabs the top 10 scores, sorting by score and timestamp.
- $query = "SELECT * FROM Score ORDER by score DESC, ts ASC LIMIT 10";
- $result = mysql_query($query) or die('Query failed: ' . mysql_error());
- //We find our number of rows
- $result_length = mysql_num_rows($result);
- //And now iterate through our results
- for($i = 0; $i < $result_length; $i++)
- {
- $row = mysql_fetch_array($result);
- echo $row['name'] . "\t" . $row['score'] . "\n"; // And output them
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement