MSSQL arguments in PHP

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • printline
    New Member
    • Jul 2006
    • 89

    MSSQL arguments in PHP

    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;
    }
    }
Working...