ERROR WITH MY PHPCODE filtervalues loop (1 Viewer)

adewale4favour

Registered User.
Local time
Yesterday, 21:53
Joined
Aug 9, 2019
Messages
39
Hi,
Really would appreciate your support here. I have a project, part of the module in this is to build html form tied to sql database where values can be filter. I am trying to use the php script to get this done. But I have a challenge as some sort of error keep coming up. Code as below:

$filtervalues = $_GET['search'];
$query = "SELECT * FROM users WHERE CONCAT(CabNo, TruckNo, driverSAP) LIKE '%$filtervalues%'";
$query_run = mysqli_query($conn, $query);
if(mysqli_num_rows($query_run)>0)

From the code, the error throwing up is from the bold script; error is as below:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\fleetrecords\process.php on line 8
No Record Found

I am pretty new with coding in php, kindly see if you could help out.

Thanks. I will provide any other request
 

Users who are viewing this thread

Top Bottom