Hello friends. I am running this query but it's not working
<?php
$check = "SELECT * FROM 'users' WHERE username = '$username' && password = '$password'";
$check = mysqli_query($dbconnect, $check) or die (mysqli_error($dbconnect));
$result = mysqli_num_rows($check);
if ($result == 0){
echo "<p><p1>Username not found. Please try again</p></p1>";
} else {
echo "Login successful. You will be redirected in a moment";
header ('location: memberarea.php');
}
?>
It's giving me this error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near WHERE = username