'while' not picking up on first DB record

[Roger Spears <roger@bgnet.bgsu.edu>]

Hello,

Can anyone from the lists please tell me why this bit of code is not 
picking up on the first record in the database?  If the 'id' I'm looking 
for is '1' it doesn't populate the _SESSION variables.  Any 'id' greater 
then '1' will populate the _SESSION variables.

$q = "SELECT * FROM employee";
$r = mysql_query($q);
$row = mysql_fetch_array($r);

while ($row = mysql_fetch_array($r))
 {
   if ($employee == $row["id"])
   {
   $_SESSION['dear'] = $row["last_name"];
   $_SESSION['to_email'] = $row["email"];
   }
 }

Thanks,
Roger

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php