php help，如何显示我自己的“订单”或提交订单

Question

I'm creating code for "transaction logs" for users to check their own order list.

I can probably echo like this

<th>Order ID</th> 
<td><?echo $row->orderid?></td>

but then again I want to know: how do I call my own order? So specifically I'm using userID 1.

Here are the transactions made by userID/CustomerID 1

How would I achieve that?

Answer 1

Select * from tablename where customerID = 1

just change tablename with name of your table