probleme requete et mysql_num_rows
Bonjour
j'ai le message d'erreur suivant :
Warning: mysql_num_rows() expects parameter 1 to be resource,
visiblement un probleme dans ma requete , mais la je ne vois pas .
mon code :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| $con = mysqli_connect($host, $username, $password, $db_name);
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysqli_real_escape_string($con,$myusername);
$mypassword = mysqli_real_escape_string($con,$mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result= mysqli_query($con, $sql);
$count=mysql_num_rows($result);
if($count==1){
$_SESSION['myusername'] = $myusername;
header("location:home.php");
}
elseif($count==0) {
header("location:index.php");
} |
merci pour votre aide