Hi
I have a login to a page and I want to display user details on that page - based on user id but can't get it working
<?php require_once('../Connections/own_local.php'); ?>
<?
$userid = $HTTP_SESSION_VARS["MM_Username"];
function rsgetuser($userid)
{
$db = mysql_select_db("members")
or die ("<p align=center><font face=verdana size=1>couldn't select db</font></p>");
$query = "SELECT company, email FROM memberlist WHERE username =" . $HTTP_SESSION_VARS['MM_Username'];
$result = mysql_query($query)
or die ("<p align=center><font face=verdana size=1>couldn't execute query</font></p>");
return mysql_fetch_array($result.MySQL_ASSOC);
}
$userid = $HTTP_SESSION_VARS["MM_Username"];
$company = $rsgetuser["company"];
$email = $rsgetuser["email"];
echo $userid;
echo $company;
echo $email;
?>
but the only thing that echoes is the userid!!
Anyone got any suggestions??
