how to compare the user input form data from database and if it's all ready in database the give msg all ready exist.

Question

how to compare the user input form data from database and if it's all ready in database the give msg all ready exist. If it is not avaliabe the add to database..

Answer 1

$entry="some name here";

$result=mysqli_query(

"SELECT * FROM students WHERE name==' ".$entry." 'LIMIT=1"

);

if(mysqli_fetch_array($result)!==false)
echo "entry already exists";

Answer 2

Not working