在浏览器中多次显示价格[关闭]

Question

I have 3 meals in the database. When I display my query it shows 3 prices. How do I only show one result instead?

$result = mysqli_query($con, "SELECT meal, price FROM Meals");

while  ($row = $result->fetch_assoc())  {
    echo '<input name="price" type="text" value="'.$row['price'].'" />';
}

Answer 1

You'll want to use the MySQL LIMIT clause.

$result = mysqli_query($con, "SELECT meal, price FROM Meals LIMIT 1");

From the MySQL manual:

With one argument, the value specifies the number of rows to return from the beginning of the result set.

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return.