รบกวนช่วยดูเกี่ยวกับการดึงรายการสั่งซื้อสินค้าหน่อยครับ

$query_cartdone = "SELECT * FROM  order as o, order_detail as d,product as p WHERE o.order_id AND o.order_id=d.order_id AND d.pro_id=p.pro_id ORDER BY o.order_date ASC";
        $cartdone = mysqli_query($con, $query_cartdone) or die(mysqli_error());
        while ($row_cartdone = mysqli_fetch_assoc($cartdone)) {
            ?>
            <tr>
                <td align = "center"><?php echo $row_cartdone['orderd_id']; ?></td>
                <td><?php echo $row_cartdone['pro_name']; ?></td>
                <td align="center"><?php echo $row_cartdone['orderd_price']; ?></td>
                <td align="center"><?php echo $row_cartdone['orderd_quantity']; ?></td>
                <td align="center"><?php echo number_format($row_cartdone['order_total'], 2); ?></td>
            </tr> 
            <?php
            $sum = $row_cartdone['orderd_price'] * $row_cartdone['orderd_quantity'];
            $order_total += $sum;
            //echo $total;
            ?>
            <?php
        }
        ?>
        <tr>
            <td colspan="4" align="center">รวม</td>
            <td align="center"><b> <?php echo number_format($order_total, 2); ?></b></td>
        </tr>