使用php在列中显示2条记录

So I have a code

<?php
$showorder = "SELECT order_number FROM orders WHERE customer_number=522";
$orderesult = mysqli_query($con, $showorder);
$ord = mysqli_fetch_array($orderesult);
?>

in my database customer number 522 has 2 order numbers, when i tried to show the result, it only shows 1.

Here's my other code

echo "<table>";
echo "<th>Order Number</th><th>Order date</th>";
echo "<tr><td>";
echo $ord["order_number"];
echo "</td><td>";
echo $ord["order_date"];
echo "</td></tr>";

You just need to use while() here for getting all records, something like:

while($ord = mysqli_fetch_array($orderesult)){
   //echo all value here
}

Also note that, if you want to print $ord["order_date"] than you must need to select column also in your query.

Otherwise, $ord will only contain order_number value.

Your SQL is missing the extra column.

Current SQL:

SELECT order_number FROM orders WHERE customer_number=522

Change to:

SELECT order_number, order_date FROM orders WHERE customer_number=522

 echo "<table>";
 echo "<th>Order Number</th>";

 while($ord = mysqli_fetch_array($orderesult)) {

   echo "<tr><td>";
   echo $ord["order_number"];

   echo "</td></tr>";

 }

you must use loop to show all result , and you can use echo one time .

while($ord = mysqli_fetch_array($orderesult)) {
    echo "<table>
    <th>Order Number</th><th>Order date</th>
    <tr><td>".
    $ord["order_number"]."
    </td></tr>";
}

Put mysqli_fetch_array($orderesult); in a while loop.

    while($ord = mysqli_fetch_array($orderesult)) {
        echo $ord["order_number"];
        # code
    }

Replace your code with the below code and then try again

<?php
    $showorder = "SELECT order_number, order_date FROM orders WHERE customer_number=522";
    $orderesult = mysqli_query($con, $showorder);

    echo "<table>";
    echo "<tr>";
    echo "<th>Order Number</th><th>Order date</th>";
    echo "</tr>";
    while($ord = mysqli_fetch_array($orderesult)) {
        echo "<tr>";
        echo "<td>$ord['order_number']</td>";
        echo "<td>$ord['order_date']</td>";
        echo "</tr>";
    }
    echo "</table>";
?>