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\b acon\login.php on line 19
Warning: mssql_fetch_arr ay(): supplied argument is not a valid MS SQL-result resource in d:\WebHoteller\ printline\www\b acon\login.php on line 20
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in d:\WebHoteller\ printline\www\b acon\login.php on line 30
Warning: mssql_num_rows( ): supplied argument is not a valid MS SQL-result resource in d:\WebHoteller\ printline\www\b acon\login.php on line 31
My login.php file:
session_start() ;
$badID = false;
session_registe r("LoggedIn") ;
$_SESSION['LoggedIn'] = true;
$cUser = "";
if (isset($_COOKIE['cUserLogin'])) {
$cUser = $_COOKIE['cUserLogin']; }
if(!empty($_POS T['key'])) {
$a = $_POST['txtUserID'];
$b = $_POST['txtPassword'];
include("./connopenphp2.in c");
session_registe r("UserID");
$_SESSION['UserID'] = $a;
$_SESSION['Password'] = $b;
session_registe r("Password") ;
$query = "select * from SysParms";
Line 19 $result = mssql_query($qu ery,$conn);
Line 20 $SysParms = mssql_fetch_arr ay($result);
session_registe r("WebCompanyNa me");
$_SESSION['WebCompanyName '] = trim($sysparms['WebName']);
session_registe r("WebName");
$_SESSION['WebName'] = trim($sysparms['WebName']);
session_registe r("DisplayState ");
$_SESSION['DisplayState'] = Trim($sysparms['DisplayState']);
$errormessage = "";
$query = "select * from USERINFO where (UserID = '" . $a . "' and Password = '" . $b . "')";
Line 30 $result = mssql_query($qu ery,$conn);
Line 31 if (mssql_num_rows ($result) > 0) {
$userinfo = mssql_fetch_arr ay($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("cUse rLogin", $a);
} else {
setcookie("cUse rLogin", "");
};
session_registe r("SalesRepID") ;
$_SESSION['SalesRepID'] = $userinfo['SalesRepID'];
session_registe r("ShowDetails" );
$_SESSION['ShowDetails'] = $userinfo['ShowMoveDetail s'];
$_SESSION['LoggedIn'] = true;
session_registe r("CurrentlyLog gedInUser");
$_SESSION['CurrentlyLogge dInUser'] = $userinfo['FirstName'] . " " . $userinfo['LastName'];
@include("searc h0.php");
return;
}
}
else {
$badID = true;
}
}
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\b acon\login.php on line 19
Warning: mssql_fetch_arr ay(): supplied argument is not a valid MS SQL-result resource in d:\WebHoteller\ printline\www\b acon\login.php on line 20
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in d:\WebHoteller\ printline\www\b acon\login.php on line 30
Warning: mssql_num_rows( ): supplied argument is not a valid MS SQL-result resource in d:\WebHoteller\ printline\www\b acon\login.php on line 31
My login.php file:
session_start() ;
$badID = false;
session_registe r("LoggedIn") ;
$_SESSION['LoggedIn'] = true;
$cUser = "";
if (isset($_COOKIE['cUserLogin'])) {
$cUser = $_COOKIE['cUserLogin']; }
if(!empty($_POS T['key'])) {
$a = $_POST['txtUserID'];
$b = $_POST['txtPassword'];
include("./connopenphp2.in c");
session_registe r("UserID");
$_SESSION['UserID'] = $a;
$_SESSION['Password'] = $b;
session_registe r("Password") ;
$query = "select * from SysParms";
Line 19 $result = mssql_query($qu ery,$conn);
Line 20 $SysParms = mssql_fetch_arr ay($result);
session_registe r("WebCompanyNa me");
$_SESSION['WebCompanyName '] = trim($sysparms['WebName']);
session_registe r("WebName");
$_SESSION['WebName'] = trim($sysparms['WebName']);
session_registe r("DisplayState ");
$_SESSION['DisplayState'] = Trim($sysparms['DisplayState']);
$errormessage = "";
$query = "select * from USERINFO where (UserID = '" . $a . "' and Password = '" . $b . "')";
Line 30 $result = mssql_query($qu ery,$conn);
Line 31 if (mssql_num_rows ($result) > 0) {
$userinfo = mssql_fetch_arr ay($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("cUse rLogin", $a);
} else {
setcookie("cUse rLogin", "");
};
session_registe r("SalesRepID") ;
$_SESSION['SalesRepID'] = $userinfo['SalesRepID'];
session_registe r("ShowDetails" );
$_SESSION['ShowDetails'] = $userinfo['ShowMoveDetail s'];
$_SESSION['LoggedIn'] = true;
session_registe r("CurrentlyLog gedInUser");
$_SESSION['CurrentlyLogge dInUser'] = $userinfo['FirstName'] . " " . $userinfo['LastName'];
@include("searc h0.php");
return;
}
}
else {
$badID = true;
}
}