Hello!
I am not at all good at sql, so can anyone tell me what this error i get means.......
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in d:\WebHoteller\printline\www\bacon\login.php on line 19
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in d:\WebHoteller\printline\www\bacon\login.php on line 20
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in d:\WebHoteller\printline\www\bacon\login.php on line 30
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in d:\WebHoteller\printline\www\bacon\login.php on line 31
My login.php file:
session_start();
$badID = false;
session_register("LoggedIn");
$_SESSION['LoggedIn'] = true;
$cUser = "";
if (isset($_COOKIE['cUserLogin'])) {
$cUser = $_COOKIE['cUserLogin']; }
if(!empty($_POST['key'])) {
$a = $_POST['txtUserID'];
$b = $_POST['txtPassword'];
include("./connopenphp2.inc");
session_register("UserID");
$_SESSION['UserID'] = $a;
$_SESSION['Password'] = $b;
session_register("Password");
$query = "select * from SysParms";
Line 19 $result = mssql_query($query,$conn);
Line 20 $SysParms = mssql_fetch_array($result);
session_register("WebCompanyName");
$_SESSION['WebCompanyName'] = trim($sysparms['WebName']);
session_register("WebName");
$_SESSION['WebName'] = trim($sysparms['WebName']);
session_register("DisplayState");
$_SESSION['DisplayState'] = Trim($sysparms['DisplayState']);
$errormessage = "";
$query = "select * from USERINFO where (UserID = '" . $a . "' and Password = '" . $b . "')";
Line 30 $result = mssql_query($query,$conn);
Line 31 if (mssql_num_rows($result) > 0) {
$userinfo = mssql_fetch_array($result);
if (trim($userinfo['UserActive']) == 'I') {
$errormessage = "Your Login ID has not been activated yet. Please try later.";
$badID = true;
}
if ($userinfo['UserActive'] != 'I') {
if (@$_POST['chkSaveCookie'] == "ON") {
setcookie("cUserLogin", $a);
} else {
setcookie("cUserLogin", "");
};
session_register("SalesRepID");
$_SESSION['SalesRepID'] = $userinfo['SalesRepID'];
session_register("ShowDetails");
$_SESSION['ShowDetails'] = $userinfo['ShowMoveDetails'];
$_SESSION['LoggedIn'] = true;
session_register("CurrentlyLoggedInUser");
$_SESSION['CurrentlyLoggedInUser'] = $userinfo['FirstName'] . " " . $userinfo['LastName'];
@include("search0.php");
return;
}
}
else {
$badID = true;
}
}