How many rows I got from SQL?

Question

I want to get some values from my MySQL database. I send a request and get the data back. Then I say: $value->fetch_assoc(). My question now is, how can I check if I got 0 Rows back or at least more than 0?

Is that right?:

if($row = $value->fetch_assoc() > 0){...}

If not, how can I check that? And I'am forced to use >= 0 or is just >0 ok? - I want only to enter the if if I got more than 0 (1 or bigger) back!

You can check the number of rows with `$value->num_rows`. http://php.net/manual/en/mysqli-result.num-rows.php - and if you do `>= 0` you include 0, so it doesn't matter how many rows are returned, 0 or one million. — Qirel, Feb 16 '17 at 20:23
To extend on this, there's *lots* of [other alternatives](http://stackoverflow.com/questions/4286586/best-way-to-check-if-mysql-results-returned-in-php), but `$value->num_rows` is definitely best. — Obsidian Age, Feb 16 '17 at 20:25
That it **literally** what `> 0` means... It checks that you get more than zero (at least 1) row returned from the query. — Obsidian Age, Feb 16 '17 at 20:26

score 1 · Accepted Answer · answered Feb 16 '17 at 20:24

1

You could check by using the variable num_rows of a query result:

if($value->num_rows > 0) {...}

Have a nice day

answered Feb 16 '17 at 20:24

Ad5001

748
5
19

How many rows I got from SQL?

1 Answers1