How to fix mysqli_num_rows error?

Question

MySQL

Hello, I have this code,

$result = mysqli_query($link, "SELECT * FROM `id` ORDER BY `data` DESC WHERE id = '1'");
     $row_cnt = mysqli_num_rows($result);

and gives the following error Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in
When "delete where id ='1'" then everything becomes normal
Please tell me how to fix it?

Answer 1

in the query, first there should be WHERE , and then ORDER / GROUP BY
you have the opposite

Answer 2

You have an error in your request. From documentation:
Swap ORDER BY ... and WHERE ...
You can also add a check: after the first line, write if ($result) { ... }. Better yet, use PDO instead of mysqli, because the former can throw exceptions.

Answer 3

$result = mysqli_query($link, "SELECT * FROM `id` ORDER BY `data` DESC WHERE id = '1'");
     $row_cnt = mysqli_num_rows($dbc, $result);

Where $dbc is a database connection (mysqli_connect())