Thank you Chris.
Albert
On Feb 20, 2006, at 5:00 PM, Chris wrote:
Albert Padley wrote:
Given the following code:
$password = (strlen($this->user_pw) < 32) ? md5($this->user_pw) :
$this->user_pw;
$sql = sprintf("SELECT COUNT(*) AS test, TeamID FROM %
s WHERE BINARY login = '%s' AND pw = '%s' AND active = 'y'",
$this- >table_name, $this->user, $password);
}
$result = mysql_query($sql) or die(mysql_error());
if (mysql_result($result, 0, "test") == 1) {
return true;
} else {
return false;
}
How would I set a session variable for the value of TeamID?
You'll need to change it so you actually fetch the teamid:
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($result);
if (empty($row)) {
return false;
}
$_SESSION['TeamID'] = (int)$row['TeamID'];
return true;
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
