Error retrieving Users from database.
". "Error: " . mysql_error()); exit(); }
$s_results = mysql_fetch_array($sql);
$userid = $s_results["UserID"];
$email = $s_results["Email"];
$firstname = $s_results["FirstName"];
$lastname = $s_results["LastName"];
// $sql1 = mysql_query("SELECT Users.UserID, Email, FirstName, LastName, NCES_Schools.LSTATE, SchoolsUsers.SchoolID, Username, Password, UsersPrivs.PrivID, NCES_Schools.LEAID, NCES_Schools.SCHNAME, NCES_Districts.NAME FROM (((Users INNER JOIN UsersPrivs ON Users.UserID = UsersPrivs.UserID) INNER JOIN SchoolsUsers ON UsersPrivs.UserID = SchoolsUsers.UserID) INNER JOIN NCES_Schools ON SchoolsUsers.SchoolID = NCES_Schools.NCESSCH) INNER JOIN NCES_Districts ON NCES_Schools.LEAID = NCES_Districts.LEAID WHERE Users.Username = '$username' AND Users.Password = '$password'");
$sql1 = mysql_query("SELECT LSTATE, NCESSCH, Leader, SCHNAME, LEAID, LEANM FROM SchoolsUsers INNER JOIN NCES_Schools ON SchoolsUsers.SchoolID = NCES_Schools.NCESSCH WHERE UserID = $userid");
if (!$sql1) { echo("Error retrieving School Users from database.
". "Error: " . mysql_error()); exit(); }
$s_results = mysql_fetch_array($sql1);
$homestate = $s_results["LSTATE"];
$homeschoolid = $s_results["NCESSCH"];
$homeschoolname = $s_results["SCHNAME"];
$homedistrictid = $s_results["LEAID"];
$homedistrictname = $s_results["LEANM"];
$state = $homestate;
include("lookup_stateproper.inc");
$homestateproper = $stateproper;
?>