Storing Session Variables From MySQL

Anon

I am attemping to store a result from a MySQL database into a session variable. However, my script never does it and the variable stays empty. I'm guessing this is a security block for PHP4 but is there any way to do what I'm trying???

[deleted]

What exactly are you trying to do? can you give a codesample?

Anon

do this:

session_start();
$id = session_id();

Then input the $id variable

Mark

Anon

Sure, here's a piece:

if ($action == "Login") {
session_register("permissions");
if (!($result = mysql_query("SELECT permissions FROM users WHERE username = '$username' AND password = '" . md5($password) . "'"))) {
mail("webmaster@", "MySQL Query Error", mysql_error());
die("Problem with MySQL query. The error has been logged and will be reviewed. Please contact <a href=\"mailto:webmaster@\">webmaster@***</a> with any questions.\n");
} elseif (($num_rows = mysql_num_rows($result)) != 0) {
while ($row = mysql_fetch_array($result)) {
$permissions = $row["permission"];
}
} else {
session_unregister("permissions");
echo("Invalid Username/Password: <a href=\"" . ADMIN . "\">Try Again</a>\n");
html_foot($directory);
exit;
}
}
}

The $permissions variable is not being set to the value of $row["permissions"]. That is the problem.

Anon

nm... my bad, miss read it