สอบถามเรื่อง code หน่อยนะค่ะ ไม่แน่ใจว่าจะ SELECT WHERE ใช้อย่างไร

<?
include("../utility.php");

connect_db(); 

$sql    = "SELECT *, tb_order.status as status, tb_order.id as id, SUM(tb_order_detail.amount*product.price*7/100+tb_order_detail.amount*product.price) as all_price FROM tb_order"
		  . " INNER JOIN member ON tb_order.UserID = member.UserID"
		  . " INNER JOIN tb_order_detail ON tb_order_detail.tb_order_id = tb_order.id"
		  . " INNER JOIN product ON tb_order_detail.product_id = product.id"
		  . " GROUP BY tb_order.id"
		  . " ORDER BY tb_order.status DESC";
$result = mysql_query($sql) or die(mysql_error());
  

$sql     = "SELECT * FROM shop";
	$result2 = mysql_query($sql) or die(mysql_error());
	$row2  = mysql_fetch_array($result2);
	  mysql_query("SET NAMES utf8");
?>
<table width="684" border="0" align="center" cellpadding="0" cellspacing="0" style="padding:20px;">
<tr>
<td width="660" height="68" align="center" >
   <h4>
     <?=$row2['Name_Shop']?>
     &nbsp;&nbsp;<br />
     ที่อยู่
     <?=$row2['Address_Shop']?>
     จังหวัด&nbsp;
     <?=$row2['Province_Shop']?>
     &nbsp;รหัสไปรษณีย์&nbsp;
     <?=$row2['Postcode_Shop']?>
     &nbsp;<br />
     เบอร์โทรศัพท์&nbsp;
     <?=$row2['Tel_Shop']?>
     อีเมล์
     <?=$row2['Email_Shop']?>
   </h4></td>
</tr>
<tr>
<td align="center"><h4>รายการสั่งซื้อ</h4></td>
</tr>
<tr>
    <td height="25" align="left">วันที่ออกรายงาน :
  <?php
// prints something like: Wednesday the 15th
echo date("Y-m-d H:i:s");?>     </td>
  </tr>

 <tr><td>
<table width="100%" border="1" cellpadding="5" cellspacing="0">
      <tr>
      	<th width="13%" height="29">เลขที่ใบสั่งซื้อ</th>
      	<th width="15%">ชื่อผู้ใช้</th>
      	<th width="34%">วันที่-เวลา</th>
      	<th width="20%">จำนวนเงิน</th>
      	<th width="18%">สถานะ</th>
      </tr>
   <? while ($row = mysql_fetch_array($result)) { ?>
      <tr>
        <td align="center"><?=$row["id"]?></a></td>
        <td><?=$row["username"]?></td>
        <td><?=$row["date"]?></td>
        <td align="right"><?=number_format($row["all_price"]) ?>
      
        </td> 

        <td><?=$row["status"]?></td>
      </tr>
  <? } ?>
</table>
</td></tr> 
<tr>
<td height="60" colspan="4" align="center">
<p style="margin:0 auto; text-align:center; width:550px;">
 <SCRIPT LANGUAGE="JavaScript">
if (window.print) {
document.write('<input type=button name=print value="พิมพ์หน้านี้" '
+ 'onClick="javascript:window.print()">');
}
</script>

  <input name="" type="button"  value="ปิดหน้านี้" onclick="window.close()"/></p>
        
     </td>
 </tr></table>