'while' not picking up on first DB record
| From: | Roger Spears | Date: | Wed, 17 Sep 2003 14:17:24 +0000 |
| Subject: | 'while' not picking up on first DB record | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-30549@lists.php.net to get a copy of this message | ||
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