Q:

How do i add another Table ROW at the end of my loop.

I would like to add a row, after the loop, the number of rows before the LAST row is random based on the user's orders. so for example the user ordered 10, i would like to add another row, to the list. even if the order is 3 there would still be another row at the end.
while ($row=mysql_fetch_array($result)){
echo "<tr>";
echo "<td>".$row['prod_name']."</td>";
echo "<td>".$row['quantity']."</td>";
echo "<td>₱".number_format(($row['price']*$row['quantity']),2)."</td>";
echo "</tr>";
        if($row['carrier']=="LBC"){
        echo "<tr>";
        echo "<td>Shippment Option Chosen: ".$row['carrier']."</td>";
        echo "<td></td>";
        echo "<td>₱250.00</td>";
        echo "</tr>";
            }
    }
echo "</table>";
?>

Here, i made it create another row, but it creates a row after each row, i just need to add 1 row at the end of the table. Thank you :)

A:

Hmm Why not just add a new query? I fixed your codes. and added these.
$qryx = "SELECT DISTINCT customers.serial,customers.name,customers.payment,customers.carrier,customers.tracking_no, orders.date, order_detail.productid, order_detail.quantity, order_detail.price, order_detail.orderid, inventory.prod_name 
        FROM customers 
        RIGHT JOIN orders on customers.serial=orders.serial 
        RIGHT JOIN order_detail on orders.serial=order_detail.orderid 
        LEFT JOIN inventory on order_detail.productid=inventory.prod_id
        where customers.email='{$_SESSION['email']}' 
        AND order_detail.orderid='{$_REQUEST['orderid']}'
        GROUP BY customers.carrier";

$resulty = @mysql_query($qryx);
while ($rowz=mysql_fetch_array($resulty)){

    if($rowz['carrier']=="LBC"){
        echo "<tr>";
        echo "<td>Shippment Option Chosen: ".$rowz['carrier']."</td>";
        echo "<td></td>";
        echo "<td>₱250.00</td>";
        echo "</tr>";
            }
        }

I changed the name of the qry, result, and row. and added DISTINCT and GROUP BY to remove redundancy.

