$sid = "dsfioiunms"; // junk ID so we don't have matching nulls when starting up
$visit_id = "nologin";
$db_name = "doghouse";
$table_name= "visitors";
$connection = @mysql_connect("localhost","admin","dcyflo") or
die("Connection error
");
$db = mysql_select_db($db_name, $connection) or
die("db selection error.");
if(!$db) echo mysql_error()."
";
$sql = "SELECT visit_userID, visit_password, visit_last, visit_first, visit_email
FROM $table_name
WHERE visit_userID = \"$id\"
AND visit_password = \"$pw\"
";
$result = mysql_query($sql,$connection) or
die(mysql_error()."
");
if ( mysql_affected_rows() >= 1 ) {
while ($row = mysql_fetch_array($result)) {
$sid = $row["visit_userID"];
$pw = $row["visit_password"];
$last = $row["visit_last"];
$first = $row["visit_first"];
$email = $row["visit_email"];
}
}
if ($op == "ds") {
if ($sid != $id) {
$msg = "
Invalid login - Try again
"; $admin = "invalid"; } else { $msg = "$sid $id" ; $admin = $sid; $visit_id= $sid; } } if ($admin != $visit_id ) { $display_block = "