help with if statement

[MDanz]

how do i say if user doesn't exist.  that below shows the avatar correctly for the user posting. How do i do if the user doesn't exist from the database?

 

$useravatar = mysql_query("SELECT * FROM Users WHERE username='$username1'")or die (mysql_error());

while($row5 = mysql_fetch_array($useravatar)){

  $image = $row5['avatar'];

  }

[trq]

Your actual question makes little sense but you should always be checking you optained a record before using it anyway. eg;

 

if ($result = mysql_query("SELECT avatar FROM Users WHERE username='$username1'") {
  if (mysql_num_rows($result)) {
    $row = mysql_fetch_assoc($result);
    $image = $row['avatar'];
  } else {
    // no record found.
  }
} else {
  trigger_error(mysql_error());
}