[PHP/MYSQL]Displays Rankings

[Amandy]

I'm really rusty in PHP , I was wondering if some one could whip up a simple PHP script that grabs the user's from a MSQL table and order's them by Level Thanks in advance.

 

[zarut]

I assume u know how to setup php to connect ur db.

'SELECT Users FROM Table order by Level desc'

Remember change Users to whatever you want load,
Table to table where you want load,
and Level to match ur table level (like if collum says wLevel change it to wLevel)

 

[Amandy]

I was wondering How can I display that with HTML? I've tried it and didn't succeed

 

[Daevius]

Example script from ww.php.net/mysql

<?php
// Connecting, selecting database
$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
    or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('my_database') or die('Could not select database');

// Performing SQL query
$query = 'SELECT * FROM my_table';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($line as $col_value) {
        echo "\t\t<td>$col_value</td>\n";
    }
    echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?>

 

[Amandy]

Thanks for your help , I just want to display the Character's name after I get the , necessary information displayed. All I've added in the script was this

$query = 'SELECT * FROM cq_user order by Level DESC';

Here's the website http://pbgunz.sytes.net/test.php

 

[zarut]

PHP Tutorial - Introduction easy tutorials ;o