$id = $_REQUEST["id"];
include("$opendatabase");
$query = "SELECT * FROM tbt_members WHERE `id`='$id'";
$result = mysql_query($query) or die("Couldn't execute query (get user data): ".mysql_error());
$num = mysql_num_rows($result);
if ($num == 0)
{
echo "server returned zero records (??)";
}
elseif ($num == 1)
{
$id = mysql_result($result, 0, "id");
$user = mysql_result($result, 0, "user");
$email = mysql_result($result, 0, "email");
$forename = mysql_result($result, 0, "forename");
$surname = mysql_result($result, 0, "surname");
$gender = mysql_result($result, 0, "gender");
$location = mysql_result($result, 0, "location");
$www = mysql_result($result, 0, "www");
$interests = mysql_result($result, 0, "interests");
$ip = mysql_result($result, 0, "ip");
$group = mysql_result($result, 0, "group");
$datereg = mysql_result($result, 0, "datereg");
$timereg = mysql_result($result, 0, "timereg");
$datelog = mysql_result($result, 0, "datelog");
$timelog = mysql_result($result, 0, "timelog");
$icq = mysql_result($result, 0, "icq");
$aol = mysql_result($result, 0, "aol");
$title = mysql_result($result, 0, "title");
$favpoem = mysql_result($result, 0, "favpoem");
$favpoet = mysql_result($result, 0, "favpoet");
$hitsprofile = mysql_result($result, 0, "hitsprofile");
$emailonpm = mysql_result($result, 0, "emailonpm");
$emailonmod = mysql_result($result, 0, "emailonmod");
$emailoncomment = mysql_result($result, 0, "emailoncomment");
$emailonnewsletter = mysql_result($result, 0, "emailonnewsletter");
$referer = mysql_result($result, 0, "referer");
echo "$user's profile
";
echo "userid: $id
email: ok
forename: $forename
surname: $surname
gender: $gender
location: $location
www: $www
interests: $interests
lastip: $ip
group: $group
datereg: $datereg
timereg: $timereg
datelog: $datelog
timelog: $timelog
icq: $icq
aol: $aol
title: $title
favpoem: $favpoem
favpoet: $favpoet
hitsprofile: $hitsprofile
emailonpm: $emailonpm
emailonmod: $emailonmod
emailoncomment: $emailoncomment
emailonnewsletter: $emailonnewsletter
referer: $referer ";
}
else
{
echo "Serious error - 2 poems of the same name exist, OH THE HUMANITY!!!!!!!!!!";
}
?>