[SOLVED] Help calling data from table

[ambo]

I need help calling data from table for userid so when they login there profile has a

 

gender

Name

Email

 

i have the table information de_user  ( email , sex , name)

[genericnumber1]

you need to have an auto_increment int column userid... add one.

 

After that,

$someUserId = 23523;
$query = "SELECT * FROM de_user WHERE userid = '$someUserId'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
echo "{$row['email']}<br />{$row['name']}<br />{$row['sex']}";

[ambo]

Thanks that worked i used $someUserId = $session[userid];

[genericnumber1]

You might want to clarify the variable name, I did that as an example. And don't just copy the code! Figure out how it works!