15 подписчиков

ORDER BY

5 сентября 20225 сен 2022

~1 мин

<?php include 'link.php'; $sql = "SELECT * FROM price WHERE price>='1000' AND name='LG' ORDER BY price DESC"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo " id: " . $row["id"]. " ЦЕНА: " . $row["price"]; } } else { echo " НИЧЕГО НЕ НАЙДЕНО!"; } $conn->close(); ?>

<?php

include 'link.php';

$sql = "SELECT * FROM price WHERE price>='1000' AND name='LG' ORDER BY price DESC";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

echo " id: " . $row["id"]. " ЦЕНА: " . $row["price"];

}

} else {

echo " НИЧЕГО НЕ НАЙДЕНО!";

}

$conn->close();