Check whether mysql query returned an empty resultset

Question

I have the following mysql query executed --

$stmt = $linkID1->prepare("select fstatus from cae_friends where provider_email=? and request_email=?");
$stmt->bind_param("ss", $uid,$row['email']);
$stmt->execute();
$stmt->bind_result($fstatus);
$stmt->fetch();
$stmt->close();

Now how do I determine whether my query returned any reslutset or its empty. Kindly help

please add the relevant programming language tag, are you working with php? — Imran Ali, Sep 24 '17 at 08:55

score 0 · Accepted Answer · answered Sep 24 '17 at 09:26

Finally i got the solution, may be its not the smarter way, but my purpose is solved. I changed the query as --

$stmt = $linkID1->prepare("select count(fstatus),fstatus from cae_friends where provider_email=? and request_email=?");
                            $stmt->bind_param("ss", $uid,$row['email']);
                            $stmt->execute();
                            $stmt->bind_result($val,$fstatus);
                            $stmt->fetch();


                            echo "Row Count : ".$val;

Now $val is giving out the right output. Thanks guys

Check whether mysql query returned an empty resultset

1 Answers1