PHP无法打印mysql_query（）结果

Question

I have code

$email = "[e-mail]";    
$row = mysql_query("SELECT EXISTS(SELECT email FROM accounts WHERE email='".$email."');");
echo $row[0];

However, nothing is echoed.

This is strange because something is being returned because, later in the code I have a function that is CALLED:

if ( $row[0] == 0 ) { echo "Email address is available<br>";};

However: this is strange because when i put the SAME CODE into mySQL database command prompt:

It clearly returns 1 or TRUE.

The mysql_query is returning 0 when the same exact command in mysql command prompt returns 1. Further: I am unable to echo the result for debugging purposes.

EDIT: Please not, the regular mySQL command is returning this and ONLY this:

EDIT: Here is there entire database:

Answer 1

MySQL query gives you a ressource. After that you have to fetch the data with mysql_fetch_assoc or mysql_fetch_row or something else for example. But its better to use prepared statements with mysqli or PDO to get more security.

$email = "[e-mail]";    
$res = mysql_query("SELECT EXISTS(SELECT email FROM accounts WHERE email='".myql_real_escape_string($email)."')");
$row = mysql_fetch_assoc($res);
echo $row['email'];

Answer to your question:

$email = "[e-mail]";    
$res = mysql_query("SELECT email FROM accounts WHERE email='".mysql_real_escape_string($email)."')");
$numRows = mysql_num_rows($res);

if($rowRows > 0) {
    echo "Record Available";
}