如何进行查询以查看特定的ID / 1行

Question

enter image description here

I have in mind that selecting such goes with the query like this

Select * from tablename where orderID = 1

how do i make not only work with 1 order id but works all view buttons depending which order ID i click to view

Answer 1

You would need to set it in the link with the view

<a href="view.php?order=<?php echo $orderID;?>">View</a>

And then on your receipt page before running the query you would do something such as

<?php
$id = $_GET['order'];
$sql = "Select * from orders where orderID = '{$id}'";
//execute sql and display...