Simply returning if a MySQL query is a valid resource...

[cgm225]

I perform the query below to check if a specific row/entry is present.  However, I have found that this only works if there is an entry present.  If there is no entry, I get the error message "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/example.com/includes/php/test.inc.php on line 13."

 

Therefore, my question is, what is the best way to simply check if a query returned any results? and then output that to a TRUE or FALSE?  Restated, how do I check if a query has returned a valid MySQL result (regardless of what the query contains)?

 

    $query = "SELECT * FROM permissions WHERE username = '$username' AND permission = '$permission'";
    $permission_results = mysql_query($query);

    while($row = mysql_fetch_array($permission_results)) {
        echo "Entry present!";}

 

Thank you all in advance!

[deansatch]

$result = mysql_num_rows($query);
if(!$result){
echo 'empty';
}
else{
crack on!...

[Barand]

Finding zero rows shouldn't give an error (false result) ???

 

But if you just want to know if it's there try

<?php
$query = "SELECT COUNT(*) FROM permissions WHERE username = '$username' AND permission = '$permission'";
    $permission_results = mysql_query($query);
$has_permission = mysql_result($permission_results, 0) > 0;