<?php
if (isset($user)) {
$db_server = "localhost";
$db_database = "members";
$db_user = "user";
$db_pass = "pass";
mysql_connect($db_server, $db_user, $db_pass) or die("Could not connect to database server.");
mysql_select_db($db_database) or die("Could not select database.");
$query = "SELECT * FROM $db_database WHERE username=$user";
$results = mysql_query($query);
$num = mysql_numrows($results);
if ($num > 0) {
$email = mysql_result($results, 0, "Email Address");
$realname = mysql_result($results, 0, "Real Name");
print "<b>Username:</b> $user<br>";
print "<b>Email:</b> $email<br>";
print "<b>Real Name:</b> $realname<br>";
$a++;
}
}
?>

<?php
//call in your connection file
require('connection2.php');

//Select from the database, the row which has the username of $_GET[profile] as give in the url. Example : url.com?a=account&s=session&profile=Test
$query=mysql_query("SELECT * FROM users WHERE username='$_GET[profile]'");

//Check the number of rows that are there in the database with the username of $_GET[profile], in this case Test is the account.
$count_rows=mysql_num_rows($query);

if ($count_rows >= 1) {
$r=mysql_fetch_array($query);
//above, we set $r to all the fields main display variable .
echo "Username  : $r[username] \n";
echo "Email : $r[email] \n";
echo "Rank : $r[rank] \n";

}
else {
echo "No records of user.";
}

mysql_close(connection_variable);
?>