รบกวนผู้รู้หน่อยค่ะ ต้องการให้โชว์ข้อมูลแค่ id เดียวกันกับอีกตารางคะ

mysql_select_db($database_connect, $connect);
$query_myorder_rcs = "SELECT * FROM orders ORDER BY id DESC";
$myorder_rcs = mysql_query($query_myorder_rcs, $connect) or die(mysql_error());
$row_myorder_rcs = mysql_fetch_assoc($myorder_rcs);
$totalRows_myorder_rcs = mysql_num_rows($myorder_rcs);

$colname_myorder_detail_rcs = "-1";
if (isset($_GET['id'])) {
  $colname_myorder_detail_rcs = $_GET['id'];
}
mysql_select_db($database_connect, $connect);
$query_myorder_detail_rcs = sprintf("SELECT * FROM order_details WHERE id = %s", GetSQLValueString($colname_myorder_detail_rcs, "int"));
$myorder_detail_rcs = mysql_query($query_myorder_detail_rcs, $connect) or die(mysql_error());
$row_myorder_detail_rcs = mysql_fetch_assoc($myorder_detail_rcs);
$totalRows_myorder_detail_rcs = mysql_num_rows($myorder_detail_rcs);

<td><a class="btn btn-success btn-lg" href="myorder_detail.php?id=<?php echo $row_myorder_detail_rcs['id']; ?>">รายละเอียด</a></td>

<?php
mysql_free_result($myorder_rcs);

mysql_free_result($myorder_detail_rcs);

mysql_close();
?>

mysql_select_db($database_connect, $connect);
$query_myorder_detail_rcs = "SELECT * FROM order_details";
$myorder_detail_rcs = mysql_query($query_myorder_detail_rcs, $connect) or die(mysql_error());
$row_myorder_detail_rcs = mysql_fetch_assoc($myorder_detail_rcs);
$totalRows_myorder_detail_rcs = mysql_num_rows($myorder_detail_rcs);

<table border="0" align="center" class="table-striped table">
  <tr>
  	<td>order_id</td>
    <td>product_id</td>
    <td>order_detail_quantity</td>
    <td>order_detail_price</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_myorder_detail_rcs['order_id']; ?></td>
      <td><?php echo $row_myorder_detail_rcs['product_id']; ?></td>
      <td><?php echo $row_myorder_detail_rcs['order_detail_quantity']; ?></td>
      <td><?php echo $row_myorder_detail_rcs['order_detail_price']; ?></td>
    </tr>
    <?php } while ($row_myorder_detail_rcs = mysql_fetch_assoc($myorder_detail_rcs)); ?>
</table>

<?php
mysql_free_result($myorder_detail_rcs);

mysql_close();
?>

$id = filter_input(INPUT_GET, 'id', FILTER_SANITIZE_NUMBER_INT);

$query_myorder_detail_rcs = "SELECT * FROM order_details WHERE id = " . $id;

mysql_select_db($database_connect, $connect);
$id = filter_input(INPUT_GET, 'id', FILTER_SANITIZE_NUMBER_INT);
$query_myorder_detail_rcs = "SELECT * FROM order_details WHERE id = " . $id;
$myorder_detail_rcs = mysql_query($query_myorder_detail_rcs, $connect) or die(mysql_error());
$row_myorder_detail_rcs = mysql_fetch_assoc($myorder_detail_rcs);
$totalRows_myorder_detail_rcs = mysql_num_rows($myorder_detail_rcs);

<?php require_once('../Connections/connect.php'); ?>