ALTER TABLE `members` ADD `mainhotel` VARCHAR(225) NOT NULL DEFAULT '';
ALTER TABLE `members` ADD `habboname` VARCHAR(225) NOT NULL DEFAULT '';
ALTER TABLE `members` ADD `favn` VARCHAR(225) NOT NULL DEFAULT '';
ALTER TABLE `members` ADD `favr` VARCHAR(225) NOT NULL DEFAULT '';
ALTER TABLE `members` ADD `favx` VARCHAR(225) NOT NULL DEFAULT '';
ALTER TABLE `members` ADD `favs` VARCHAR(225) NOT NULL DEFAULT '';
ALTER TABLE `members` ADD `fws` VARCHAR(225) NOT NULL DEFAULT '';
ALTER TABLE `members` ADD `fc` VARCHAR(225) NOT NULL DEFAULT '';
ALTER TABLE `members` ADD `hm` VARCHAR(225) NOT NULL DEFAULT '';

<?php
session_start(); //allows session
include "config.php";
echo "<center>";
if(isset($_GET['user'])){ //if there trying to view a profile
//gets the user name and makes it safe
$username = addslashes($_GET[user]);
//querys the db to find the username
$getuser = mysql_query("SELECT * FROM `members` WHERE `username` = '$username'");
//checks see if the username exists in the db

$usernum = mysql_num_rows($getuser);
//if it don't exist
if ($usernum == 0)

{
//don't exist

echo ("User Not Found");

}
//if it does exist then show there profile
else
{
$user = mysql_fetch_array($getuser);
echo "<fieldset style='width: 350'>
<b>$user[username]'s Profile</b><br><br>
Email: $user[email]<br>
Location: $user[location]<br>
Sex: $user[sex]<br>
Age: $user[age]<BR>
Main Hotel: $user[mainhotel]<BR>
Habbo Name: $user[habboname]<BR>
Favorite Norm: $user[favn]<BR>
Favorite rare: $user[favr]<BR>
Favorite Habbo X: $user[favx]<BR>
Favorite Habbo Staff: $user[favs]<BR>
Favorite WeHabbo Staff: $user[fws]<BR>
Favorite Color: $user[fc]<BR>
Habbo Home: $user[hm]
</fieldset>";

}
}
else
{
//gets all the members from the database
$getusers = mysql_query("SELECT * FROM `members` ORDER BY `id` ASC") or die(mysql_error());
//loops there name out
while ($user = mysql_fetch_array($getusers))
{
echo "<a href='members.php?user=$user[username]'>$user[username]</a><br>";
}
}
echo "<center>";
?>