Using MySQL Result in PHP4 Session

[Anon]

How can I use the result from a MySQL query is a session variable in PHP4? $permissions is not being set to the value of $row["permissions"]. See example code below:

session_register("permissions");
$result = mysql_query("SELECT permissions FROM advertisers WHERE username = '$username' AND password = '" . md5($password) . "'");
while ($row = mysql_fetch_array($result)) {
$permissions = $row["permissions"];
}
echo($permissions);

// Mr. Greene

[eduard]

What's the error you get?

[Anon]

There is no error. The variable simply stays blank.

echo($permission);

= blank!