I am getting an error in num_rows property in php mysql
My code:-
<?php
require ('connect.php');
$inputemail = $_POST['email'];
$sql = "SELECT*FROM accounts WHERE Email='$inputemail' ";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
die ("Email is already registered....");
}
else {
echo "Congrats!!";
}
?>
Error:-
Notice: Trying to get property 'num_rows' of non-object
But this is working:-
<?php
require ('connect.php');
$inputemail = $_POST['email'];
$sql = "SELECT*FROM accounts ";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
die ("Email is already registered....");
}
else {
echo "Congrats!!";
}
?>
Why??
