mysql - Query Checking for Existence - PHP -

mysql - Query Checking for Existence - PHP -

i'm trying to test see if email address exists in database running query check.

i can connect database fine.

however no matter what, if email exists returns "doesn't exist".

<?php //----------------------------------------------------------------------------------// //setup require_once('sb_constants.php'); //----------------------------------------------------------------------------------// //connect database //----------------------------------------------------------------------------------// $connection = mysqli_connect(database_host, save_username, save_password, database_name); // check connection successful if (mysqli_connect_errno($connection)) { header('http/1.0 500 internal server error', true, 500); die(failedtoaccessdatabase . ". failed connect database"); } else { echo "connection success!"; } //query check $assessoremail = mysqli_query($connection, "select email_address assessorid email_address = 'ryan@ablah.com'"); if (mysqli_num_rows($query_identifier) == 0) { die(unregisteredassessor . ". doesn't exist"); } else { // exists echo "exists getting ace id."; //get assessor id $result = mysqli_query($connection, "select ace_id assessorid email_address = 'ryan@blah.com'"); echo $result; } /* close connection */ mysqli_close($connection); ?>

any ideas of problem? :)

various mistakes. fix:

$assessoremail = mysqli_query($connection, "select ace_id,email_address assessorid email_address = 'ryan@ablah.com'"); if (mysqli_num_rows($assessoremail) == 0) { die(unregisteredassessor . ". doesn't exist"); } else { // exists echo "exists getting ace id."; //get assessor id $result = mysqli_fetch_assoc($assessoremail); echo $result['ace_id']; }

php mysql database