php - mysql 查询不好，我需要帮助才能从我的数据库中显示我的产品

Question

    $consulta1="SELECT * FROM PRODUCTO LIMIT $empezarDesde,$contenidoPorPagina 
WHERE FAMILIA BETWEEN 0 AND 5 ORDER BY FAMILIA ASC";
      $resultado1 = $mysqli->query($consulta1);

      while($dato = $resultado1->fetch_assoc()){
...
}

我正在做一个 shopWeb，但我的查询不起作用。

标签： phpmysqlphpmyadmin

Answer 1

LIMIT 应该在查询的末尾...

$consulta1="SELECT * FROM PRODUCTO  
             WHERE FAMILIA BETWEEN 0 AND 5 
             ORDER BY FAMILIA ASC
             LIMIT $empezarDesde,$contenidoPorPagina";