However,
Set up a database with table called users
in 'users' have columns
user_id, user_name, user_rank
make user_id auto increment
<?php
$db_host = "192.168.1.1"; // or whatever
$db_user = "user"; // or whatever
$db_password = "bollox"; //or whatever
mysql_connect($db_host, $db_user, $db_password);
mysql_select_db('database_name');
function add_user($user_name, $rank) {
$sql = "INSERT INTO users VALUES ('', '" . $user_name . "', '" . $rank . "'";
mysql_query($sql);
}
function update_user($user_name, $new_rank) {
$sql = "UPDATE users SET user_rank = '" . $new_rank . "' WHERE user_name = '" . $user_name . "'";
mysql_query($sql);
}
function print_data() {
$sql = "SELECT * FROM users ORDER BY 'user_rank'";
$result = mysql_query($sql);
echo '<table><tr>';
while($row = mysql_fetch_assoc($result)) {
echo '<tr><td>';
echo $row['user_name'] . '</td><td>';
echo $row['user_rank'] . '</td></tr>';
}
echo '</table>';
}
?>
thats all very basic, but it gives you an idea.
The best advice though is just to read the manual and a good book on SQL.
Gareth
