How to check whether a mysql select statement result has a value or not in php?

if ($result == false) { echo "not available"; } else { echo "available"; } 

The reason yours doesn't work is because the value of $result will not be true as it contains an array. You could do it by reversing the statement to check for false first.

You can also do it with mysql_num_rows

if (mysql_num_rows($queryres) > 0) { echo "User name taken"; } 

from http://php.net/mysql_query :

Return Values

For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.

So to start off with, your if statement will never evaluate to false, because you have the "or die" on the mysql_query (which is activate when mysql_query returns false).

But your if condition is wrong altogether, because you don't want to know if the query failed, but if any results were returned. For this you probably want to use mysql_num_rows.

As a small tip, since you only need to know if there's 1 matching username, add "LIMIT 1" to the end of your query. Then mysql will return as soon as it hits the first match, instead of searching th whole table for more results.

As an alternative method, you could use a COUNT() query, and check the number returned in the result set.

Although this question has already an adequate answer, I'll give you another option. Simply remove the "==true" in the IF condition and it will automatically test for the presence of a value instead of a boolean comparison.

if($result) // this condition will now work { echo "User Name Available"; } else { echo "Sorry user name taken"; } 

You can use this if you want to preserve the signature of your code.

$queryres = "SELECT dUser_name FROM tbl_login WHERE dUser_name='$UserName'"; $result = mysql_query($queryres,$cn) or die("Selection Query Failed !!!"); if (mysql_num_rows($result)) { echo "Username available"; } else { echo "Username not available"; } 

After Executing the Query just mysql_num_rows($result) which will return you the Count of Rows is fetched.