MySqli check to see if query has results

Question

I'm trying to find the best way to see if mysqli has results or not. I want the code to execute if it has a valid query and to do nothing if not.

Here is the code I tried that does not work:

$result = mysqli_query($con,"SELECT * FROM promoCode where code = '$code'")
    or die("Error in mySql statement!");

if (mysqli_num_rows($result)==1) { echo "yahoo it worked! "; }

You can try something to the affect of `$query = $con->query("SELECT * FROM promoCode WHERE code = '". $code ."'"); if (mysqli_num_rows($query) > 0) { echo 'Code exists.'; }` — Funk Forty Niner, Sep 30 '13 at 20:51
@fred why the change from _OOP_ to _procedural_ in the `if` statement? — Steven, Sep 30 '13 at 20:53
@Steven It's just an example which works for me. And apparently the other method below didn't work for the OP. — Funk Forty Niner, Sep 30 '13 at 20:54

score 6 · Accepted Answer · answered Sep 30 '13 at 20:45

6

==1 checks for exactly 1 record.

What you need is

if (mysqli_num_rows($result) >= 1 ) { echo "yahoo it worked! "; }

Check the documentation here

answered Sep 30 '13 at 20:45

karthikr

92,866
25
190
186

1

Check the example in the reference link (Example #2 Procedural style). You are missing the query. – karthikr Sep 30 '13 at 20:52

MySqli check to see if query has results

1 Answers1