Sorting by price or rate

Question

So this is my code, but whenever I run this code i get this message (Notice: Trying to get property 'num_rows' of non-object in F:\xampp\htdocs\php\index.php on line 31) and I can't find the problem. I always use num_rows and it works, this is the first time this happened

 <?php
$mysqli = new mysqli ('localhost','root','','instruments');
if(isset($_GET['order']))
{
$order = $_GET ['order'];
}else{
  $order = 'price';
}
if(isset($_GET['sort']))
{
$sort = $_GET ['sort'];
}else{
  $sort = 'ASC';
}

$result = $mysqli->query("SELECT * FROM bass ORDER BY $order $sort");
if($result->num_rows > 0)
{
echo "
<table border = '1'>
<tr>
<th>Price</th>
<th>Rate</th>
";
while($rows = $result->fetch_assoc())
{

      $name = $rows ['name'];
  $price = $rows ['price'];
  $rate = $rows ['rate'];
  $image = $rows ['image'];

  echo "
  <tr>
  <td>$name</td>
 <td>$price</td>
 <td>$rate</td>
 <td><img src='$image'></td>
   </tr>
  ";
}
echo "
</table>
";
}else {
  echo "Nic ni";
}
 ?>

add this after `$result = $mysqli->query(...`: `echo $mysqli->error;`. This will tell you what is wrong. maybe a table name, maybe a field name, .. — Jeff, Jun 09 '18 at 12:05
I did it like this and got the same result $result = $mysqli->query("SELECT * FROM bass ORDER BY $order $sort ") echo $mysqli->error; — Unknown, Jun 09 '18 at 12:17
_but what does the error message say_?! (in your example is the `;` missing after `..$order $sort);` — Jeff, Jun 09 '18 at 12:19
Trying to get property 'num_rows' of non-object , it only says that and nothing else — Unknown, Jun 09 '18 at 12:20

score 0 · Answer 1 · edited Jun 09 '18 at 15:46

0

Run this query in your MySQL:

SELECT * FROM bass ORDER BY price ASC

Check if you get any result. Maybe your query is returning 0 results and that's why it's failing.

edited Jun 09 '18 at 15:46

Robert Columbia

6,313
15
32
40

answered Jun 09 '18 at 11:41

yusuf dalal

1
1

Sorting by price or rate

1 Answers1