What is the problem in php code? Gets only one row, although there are more than 6 rows in the database?

Question

PHP

$orderslist = mysqli_query($con, "SELECT * FROM bills LIMIT 25");
  while($orderslist = mysqli_fetch_assoc($orderslist)){
  echo "<td>".$orderslist['id']."</td>
    <td>".$orderslist['color']."</td><td>".$orderslist['name']."</td><td>".$orderslist['telephone']."</td><td>".$orderslist['email']."</td><td>".$orderslist['adress']."</td><td>".$orderslist['count']."</td>";
 }
  echo "</tr></table></section> ";
}

Error: Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result

Answer 1

Why are you using $orderslist twice? rewrite in the loop at the first iteration, here is the result