getting info from db

[onlinenova]

i need to get my user's info from my db, but i don't no how to do it. 😕

i need to get
username
location (set by game)
money
bank
loan's
and gun + bullets

please tell me how to put the session in or the cookies where to put them and how to edit them to work

thanks

[msk_1980]

What database are you using. If mysql check this: http://au3.php.net/mysql.
The examples from the users at the bottom of the manual gives you a good idea.

If you are using any else check the php manual, php supports most of the databases.

Try to give it a go and if any problem post it back here and we will help.

[jbatson]

You might try someting like:

// db connection
// code goes here

// query db
$query = "SELECT username,location,money,bank,loans,gun,bullets FROM tablename WHERE username='onlinenova'";

// fetch results
$results = mysql_query($query);
$row = mysql_fetch_array($results);

// give db data variable names
$db_username = $row['username'];
$db_location = $row['location'];
$db_money = $row['money'];
etc !!!!!!

// output data
echo ($db_username." ==== ".$db_location." ==== ");

// close the db connection