ก่อนอื่นน่ะครับ คือผมอยากให้แสดงข้อมูลจากฐานข้อมูลที่เป็น OrderNo ของ session ที่ล็อกอิน ผมต้อง SQL แบบไหนครับ

//สมมุติผมดึง user มาตวรจสอบแล้ว
$sql="select * from Member where username ='1234' and password='1234'";
$qr=mysql_query($sql);
$sr=mysql_fetch_array($qr);

$_SESSION['memberid']=$sr[memberid];

<?
session_start();
$sql = "SELECT * FROM cusorder WHERE status = '0' and memberid='$_SESSION[memberid]'";

$result = mysql_query($sql) or die (mysql_error());
?>


<table align="center" border="1">
	<tr> 
		<td width="106">หมายเลขสั่งซื้อ</td>
        <td width="106">ชื่อลูกค้า</td>
        <td width="106">ราคาสินคาทั้งหมด</td>
        		
	</tr>
    <?
    while($row = mysql_fetch_array($result)){
	?>
	<tr> 
		<td width="106"><?=$row["OrderNo"]?></td>
        <td width="106"><? $_SESSION["strUserName"]?></td>
        <td width="106"><?=$row["Total"]?></td>
	</tr>
    <?
	}
	?>
	
</table>

<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<link href="css/styles.css" rel="stylesheet" type="text/css">
<script type="text/javascript">
var so = new SWFObject("movie.swf", "mymovie", "100", "150", "8", "#336699");
so.addParam("wmode", "transparent");
so.write("flashcontent");
</script>
<table width="168" border="0" align="left" cellpadding="0" cellspacing="0" >
  <tr> 
    <td bgcolor="#FFFFFF">
      <div id="content" align="center"><strong><center>
       <table width="100%" border="0" align="center" cellpadding="4" cellspacing="1" ><div  id="content" align="center"><img src="image/menu/welcome2.jpg" width="180" height="22" border="0" align="absbottom"></div>
        </table>    
<?
//============ ล็อกอินสมาชิก
if($_GET["action"]=="Login")
{
	$resultLogin=select("member","where 1 and UserName='".$_POST["txtUserNameSC"]."' and Password='".$_POST["txtPassSC"]."' ");
	if(!$resultLogin)
	{
						echo "<script language=\"JavaScript\">";
						echo "alert('ชื่อ และ รหัสผ่าน ไม่ถูกต้อง');";
						echo "</script>";
	}
	else
	{
						$_SESSION["strUserName"]=$_POST["txtUserNameSC"];
					  $_SESSION["strPassword"]=$_POST["txtPassSC"];
					  session_write_close();
						 header("location:index.php");
	}
}
?>
   
      <?
	if($_SESSION["strUserName"] =="")
	{
	?>

        <form action="?action=Login" method="post" name="frmLogin">
           <div>USERNAME :<center>   
              <input name="txtUserNameSC" type="text" class="txtboxlogin" id="txtUserNameSC" size="15" /></center>
            </div>
            
          <div>PASSWORD :<center>
            <input name="txtPassSC" type="password" class="txtboxlogin" id="txtPassSC" size="15" /></center>
          </div>
    
                <input name="submit" type="submit" class="btn" value="Log in" />
                <br>
                <img src="image/app_free.gif" width="16" height="16" border="0" align="absbottom"> 
                <a href="rule.php"> สมัครสมาชิก<br>
                </a><img src="image/app_free.gif" width="16" height="16" border="0" align="absbottom"> 
                <a href="forget.php"> ลืมรหัสผ่าน</a><br>
              </p>
             
        </form>
      <?
	  }
	  else
	  {
	  ?>
    

<div id="content">
   
  <div align="center"><strong>ยินดีต้อนรับ</strong></div>
       
         
          <div align="center"> <strong> <a href="profile.php"> <? echo $_SESSION["strUserName"];?></a> </strong> </div>
					<div align="center"><a href="logout.php">ออกจากระบบ</a></div>
          <div >
      <div align="center">&nbsp;<br>
        <img src="image/cart.gif" width="23" height="17" align="absmiddle"> <a href="cart.php">สินค้าในตะกร้า</a><br>
        <img src="image/create.gif" width="15" height="15" align="absmiddle"> 
        <a href="payment.php">แจ้งชำระเงิน</a><br>
        
      </div>
  <?
	  }
	  ?>
</div>
  

</div>
  </td>
  </tr>
</table>
<br>
<table width="168" border="0" align="left" cellpadding="0" cellspacing="0" >
  <tr> 
    <td bgcolor="#FFFFFF">
    <br>
<div id="content" align="center"><strong><center>
<table width="100%" border="0" align="center" cellpadding="4" cellspacing="1" >
<div  id="content" align="center"><img src="image/menu/product.jpg" width="180" height="22" border="0" align="absbottom">
</div>
</table>
  <?
			//============  แสดงรายการสินค้าแนะนำ
$sqlCatShow="select * from category where 1=1 order by CatID asc ";
$queryCatShow=mysql_query($sqlCatShow);
$i=0;
while($resutCatShow=mysql_fetch_array($queryCatShow))
{
?>
            <table width="100%" border="0" cellspacing="2" cellpadding="0">
              <tr> 
                <td width="8%">&nbsp;&nbsp;&nbsp;</td>
                <td width="7%" valign="baseline"><img src="image/mm_arrow.gif" width="4" height="7" /></td>
                <td width="85%" align="left"><span class="link-yellow"> <a href="product.php?CatID=<?=$resutCatShow["CatID"];?>"> 
                  <?=$resutCatShow["CategoryName"];?>
                  </a> 
                  <?="(".num_record("product","where 1 and CatID='".$resutCatShow["CatID"]."' ").")";?>
                  </span></td>
              </tr>
            </table>
            <?
}
?>
<p>
<strong><center>
</div>
</td>
  </tr>
</table>
<table width="168" border="0" align="left" cellpadding="0" cellspacing="0" >
  <tr> 
    <td bgcolor="#FFFFFF">
    <br>
<div id="content" align="center"><strong><center>
<table width="100%" border="0" align="center" cellpadding="4" cellspacing="1" >
<div  id="content" align="center"><img src="image/use.jpg" width="180" height="22" border="0" align="absbottom">
</div>
</table>
 <table>
 <br>
 <div align="center">
 <img src="image/howorder.jpg"  width="160" height="300" border="0" align="absbottom">
 </div>
 </table>
 <p>
 <br>
 <strong>ผู้ชมเว็บไซต์ทั้งหมด 
        
  </strong>
<span class="style3"><strong><center>
<?
		  IF ($_SESSION["strStatus"] == "")
		  {
		  update("counter","COUNTER=COUNTER+1","where 1");
		  $_SESSION["strStatus"]="Yes";
		  session_write_close();
		  	}
			$result=select("counter","where 1=1");		  
			$counter = "$result[COUNTER]";
			for ($i = 0; $i < strlen($counter); $i++) {
			echo "<img src=\"image/$counter[$i].gif\" align=\"absbottom\">";			  
		  }
		  ?>
          </center></strong></span><p>
<table width="168" border="0" align="left" cellpadding="0" cellspacing="0" >
  <tr> 
    <td bgcolor="#FFFFFF">

   <?
if($_GET["action"]=="Login")
{
	$resultLogin=select("member","where  user='".$_SESSION["status"]="admin" );
	if(!$resultLogin)
	{
						$_SESSION["status"]="admin";
						$_SESSION["adminlogin"]=true;
							session_write_close();
						 	header("location:index.php");
	}
}
?>
      <?
	if($_SESSION["adminlogin"]=="")
	{
	?>

        <div align="center"><strong>ผู้ดูแลระบบคลิกที่นี่</strong></div>      
      <div align="center"> <strong> <center>
      <img src="image/im_sm_prefs.gif" width="17" height="17"> 
          <a href="admin/index.php" target="_blank">Login</a></center></strong> </div>
      <?
	  }
	  else
	  {
	  ?>
    

<div id="content">
   
  <div align="center"><strong>ยินดีต้อนรับ</strong></div>
       
         
          <div align="center"> <strong> <a href="admin/menu2.php"> <? $_SESSION["adminlogin"];?>Admin</a> </strong> </div>
<div align="center"><a href="logout.php">ออกจากระบบ</a></div>
  <?
	  }
	  ?>
</div>
  

</div>
  </td>
  </tr>
</table>
<div id="flashsun">
                    <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="130" height="140" id="myFlashSun">
                        <param name="movie" value="flash/clockcalendarwhite.swf" />
                        <param name="loop" value="true" />
                        <param name="quality" value="best" />
                        <param name="wmode" value="transparent" />
                        <!--[if !IE]>-->
                        <object type="application/x-shockwave-flash" data="flash/clockcalendarwhite.swf" width="130" height="140">
                            <param name="loop" value="true" />
                            <param name="quality" value="best" />
                            <param name="wmode" value="transparent" />
                        <!--<![endif]-->
                            <img src="flash/clockcalendarwhite.swf"  />
                            
                        <!--[if !IE]>-->
                        </object>
                        <!--<![endif]-->
                    </object>   
                </div>
  <br>
  <br>
  <strong> <center>
  <?=date("d-m-Y");?>
  <div id="css_time_run">   
</div>  
  </center>
  </strong></div>
  </td>
  </tr>
</table>

$_SESSION["strUserName"]=$_POST["txtUserNameSC"];
$_SESSION["strPassword"]=$_POST["txtPassSC"];