Get error when retrieve data from mysql

ghjk

I want to write a php code for a login page. When I enter correct user name and password I got the error ;Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\vehiclemaster\index.php on line 22. This is my code.
Could some one help me.

Expand|Select|Wrap|Line Numbers

 
if(isset($_POST['login'])){

    $username=$_POST['username']; 

    $password=$_POST['password'];

    if((!username)||(!$password)){

        $login_error = '<p class= "errormsg">Please enter all fields</p>';

    }

        $password_encrpt = md5(substr($password, 1, -1));

        $sql = "SELECT * FROM user WHERE  Username='$username' AND Password ='$password_encrpt'"; 

        echo $sql;

        $login_check1 = mysql_num_rows($sql);

        if($login_check1==1){

            $row = mysql_fetch_array($sql);

            foreach( $row AS $key => $val )

                $$key = stripslashes( $val );

        $_SESSION['UserID_Ses'] = $UserId;

        echo $_SESSION['UserID_Ses'];
 
            $ADDERROR = "True";

        }

        else {

            $ADDERROR = '<p class="errMsg" align="Center">Invalid Username or Password</p>';

        }
 
}

Atli

Hey.

The mysql_num_rows function takes the query resource returned by mysql_query, not the SQL query itself.

See the examples in the manual entry for the function.

Samishii23

Expand|Select|Wrap|Line Numbers

 // OLD CODE

$sql = "SELECT * FROM user WHERE  Username='$username' AND Password ='$password_encrpt'";

// NEW CODE

$sql = mysql_query("SELECT * FROM user WHERE  Username='$username' AND Password ='$password_encrpt'");
 
// Should Work, Based on your code supplied...

$login_check1 = mysql_num_rows($sql);

Get error when retrieve data from mysql

re: Get error when retrieve data from mysql

re: Get error when retrieve data from mysql

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about