note 91366 deleted from control-structures.while by danbrown
| From: | danbrown@php.net | Date: | Mon, 08 Jun 2009 15:59:04 +0000 |
| Subject: | note 91366 deleted from control-structures.while by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-156478@lists.php.net to get a copy of this message | ||
Note Submitter: denniedv at gmail dot com
----
include("includes/dbconnect.php");
$sql= mysql_query("SELECT userid, Username, Password, Type
FROM tblusers
WHERE Username='$username' AND Password='$password'");
if (!$sql)
{
die(mysql_error());
}
$count = mysql_num_rows($sql);
if($count==1) {
$_SESSION['login'] = 1;
$_SESSION['username'] = $username;
$_SESSION['ip'] = $_SERVER['REMOTE_ADDR'];
while ($row = mysql_fetch_assoc($sql))
{
$_SESSION['userid'] = "{$row['userid']}";
$_SESSION['type'] = "{$row['Type']}";
}
}