[SOLVED] echo from any row

[dachshund]

hi,

 

how can i change this:

 

if($_SESSION['uid']){
  $userid = $_SESSION['uid'];
  $query = "SELECT username FROM users WHERE userid = '$userid'";
  $result = mysql_query($query);
  list($username) = mysql_fetch_row($result);
  echo "Welcome. \n";
  echo $username;
}else{

 

to:

 

$query = "SELECT * FROM users WHERE userid = '$userid'";

 

so that I can echo something like $rows['email'] as well as $rows['username']

 

thanks!

 

[smerny]

if($_SESSION['uid']){
  $userid = $_SESSION['uid'];
  $query = "SELECT * FROM users WHERE userid = '$userid'";
  $result = mysql_query($query);
  row = mysql_fetch_assoc($result);
  echo "Welcome. \n";
  echo $row['username']."\n";
  echo "Your email is ".$row['email'];
}else{

[DrTrans]

if($_SESSION['uid']){
  $userid = $_SESSION['uid'];
  $query = "SELECT username FROM users WHERE userid = '$userid'";
  $result = mysql_query($query);
  while ($row = mysql_fetch_assoc($result) {
      $username = $row['userid'];
      $email       = $row['email'];
  echo "Welcome. \n";
  echo "$username and $email";
} 
}else{