Showing MySQL details?

[Dobby]

I have this working for username

$fetch_users_data = mysql_fetch_object(mysql_query("SELECT * FROM `members` WHERE username='".$_SESSION['username']."'"));
}

But i cant get it to work for email or rank. How would i do this?

 

[JayNZ]

You need to explain what you mean by work for email or rank.. Are you trying to get the data for email and rank?

 

[Dobby]

Im trying to get a page that will show the personl that logged in their email and what rank they are

 

[NSA]

Perhaps it would be something like this:

<?php
$user = $_SESSION['username'];
$q = "SELECT * FROM members WHERE username = '$user'";
$r = mysql_query($q);
while($row = mysql_fetch_assoc($r)){
echo $row['rank'];
echo $row['email'];
}
?>

 

[Dobby]

Works!!!! THANKS