ช่วยกลับมาตอบคำถามที่073711 ด้วยค่ะ ยังทำไม่ได้เลย หรือไม่ก็ตอบในอันนี้ก้ได้ค่ะ

<? 
include"function.php";
$host="localhost";
$user_name="root";
$pass_word="root";
$db="project";
mysql_connect( $host,$user_name,$pass_word) or die ("ติดต่อไม่ได้ ");
mysql_select_db($db) or die("ติดต่อได้"); 
 mysql_query("SET NAMES utf8") or die (mysql_error());
$d=$_REQUEST['date'];
$m=$_REQUEST['month'];
$y=$_REQUEST['year'];
$keyd=$y."-".$m."-".$d;
$key=$y."-".$m;

// Customer has payment already
//$condition = " WHERE order_status='1' ";

if($_REQUEST['search']=="1") 
{
	$sql_cat="SELECT * FROM `order` WHERE date LIKE '".$keyd."' ORDER BY id DESC";
	$result_cat=mysql_query($sql_cat);
	$s1 = "checked";	
	echo $sql_cat;
}
elseif($_REQUEST['search']=="2") 
{
	$sql_cat="SELECT * FROM `order` WHERE date LIKE '".$key."-%' ORDER BY id DESC";
	$result_cat=mysql_query($sql_cat);
	$s2 = "checked";
	echo $sql_cat;
} 
elseif($_REQUEST['search']=="3") 
{
	$sql_cat="SELECT * FROM `order`  WHERE date LIKE '".$y."%' ORDER BY id DESC";
	$result_cat=mysql_query($sql_cat);
	$s3 = "checked";
	echo $sql_cat;
} 
elseif($_REQUEST['search']=="4" || $_REQUEST['search']=="") 
{
	$sql_cat="SELECT * FROM `order`  ORDER BY id DESC";
	$result_cat=mysql_query($sql_cat);
	$s4 = "checked";
	echo $sql_cat;
}

$thai_m = array("","มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");

?>
<style type="text/css">
<!--
.style28 {font-family: Geneva, Arial, Helvetica, sans-serif; color: #FFFFFF; }
-->
</style>
	
      <table width="747" border="0" align="center">
        <tr>
          <td width="622" height="30">&nbsp;</td>
        </tr>
        <tr>
          <td height="26"><div align="center">
            <div align="center"><span class="style29">
              รายการสรุปยอดขาย</span><br />
              <span class="style29">
              <?
			if($_REQUEST['search']=="1") {
				$mm = $thai_m[10];
				if($m != 10){ 
					$mm = $thai_m[str_replace(0,'',$m)];
				}				
				echo"ประจำวันที่ ".$d." ".$mm." ".$y;
			} elseif ($_REQUEST['search']=="2") {
				$mm = $thai_m[10];
				if($m != 10){ 
					$mm = $thai_m[str_replace(0,'',$m)];
				}
				echo"ประจำเดือน ".$mm." ".$y;
			} elseif ($_REQUEST['search']=="3") {
				echo"ประจำปี $y";
			}
            ?>
              </span><br />
            </div>            </td>
        </tr>
        <tr>
          <td height="41"><div align="center">
            <form  name="searchorders" method="post">
                  <label>ค้นหา ตาม &nbsp;</label>
                  <input name="search" type="radio" <?=$s1;?> value="1" />วันที่&nbsp;&nbsp;
				  <input type="radio" name="search" <?=$s2;?> value="2" />เดือน/ประจำปี 
                  <label> &nbsp;&nbsp;
                  <input type="radio" name="search" <?=$s3;?> value="3" />ปี </label>
                  <label> &nbsp;&nbsp;
                  <input type="radio" name="search" <?=$s4;?> value="4" /></label>ทั้งหมด<br />
				  <label>
            <select name="day" >
              <option value="0" selected>-----</option>
              <?
			  	for ($i=1;$i<=31;$i++) 
				{
					$sel = "";
					if($i==$d && $d!=""){ 
						$sel = 'selected'; 
					}
					
					if(strlen($i)=="1") {
						echo "<option $sel value='$i'>0$i</option>";
					} else {
						echo "<option $sel value='$i'>$i</option>"; 
					}
				}
			  ?>
            </select>
</label>
<label>
            <select name="month">
              <option value="0" selected>--------------</option>
              <?
			  for($i=1;$i<=12;$i++) 
			  {
				$sel = "";
				if($i==$m && $d!=""){ 
					$sel = 'selected'; 
				}
				if(strlen($i)=="1") {
					echo "<option $sel value='$i'>$thai_m[$i]</option>";
				}else{
					echo "<option $sel value='$i'>$thai_m[$i]</option>"; 
				}
			  }  
			  ?>
            </select>
</label>
<label>
			<input name="year" type="text"  value="<?=date("Y")+543;?>" size="4" maxlength="4" />
</label>
<label>
			<input type="submit"  value="ค้นหา" />
</label>
    </form>
          </div>            <div align="center"></div>            <div align="center"></div></td>
        </tr>
        
  
      </table>
      <strong> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</strong>
                             
      <table width="747" border="0" align="center">
        <tr>
          <td width="100" bgcolor="#95AFFF"><div align="center"><strong>เลขที่ใบสั่งซื้อ</strong></div></td>
          <td colspan="2" bgcolor="#95AFFF"><div align="center"><strong>วันที่ -เวลา   </strong></div></td>
          <td width="247" bgcolor="#95AFFF"><div align="center"><strong>ชื่อสมาชิก</strong></div></td>
          <td width="167" bgcolor="#95AFFF"><div align="center"><strong>จำนวนเงิน</strong></div></td>
         <?
	 while($dbarr_cat= mysql_fetch_array($result_cat)) {	
 $sqlm="SELECT *,`order`.id as id,"
." SUM(order_detail.amount1*product.price2+product.price3) as all_price"
." FROM `order`"
." INNER JOIN member ON `order`.member_id=member.id"
." INNER JOIN order_detail ON order_detail.id_order=`order`.id"
." INNER JOIN product ON order_detail.product_id=product.id"
." GROUP BY `order`.id"
." ORDER BY `order`.id";
		  
	
		 $rem=mysql_query($sqlm);
		 $dbarrm=mysql_fetch_array($rem);
$sum=$sum+$dbarrm['all_price'];
	//echo $sum;
	//echo $dbarrm['all_price'];
		   ?>
	    </tr>
      
        <tr>
          <td valign="top" bgcolor="#FFFFFF"><div align="center">
              <?=$dbarr_cat['id'];?>
          </div></td>
          <td colspan="2" valign="top" bgcolor="#FFFFFF"><div align="center">
              <?
			$oldyear = substr($dbarr_cat['date'],0,4);
			$thyear = $oldyear;
			$dbarr_cat['date'] = str_replace($oldyear, $thyear, $dbarr_cat['date']);
            echo ($dbarr_cat['date']);
			?> <?=$dbarr_cat['datetime']?>
          </div></td>
          <td valign="top" bgcolor="#FFFFFF"><div align="center">
            <?=$dbarrm["username"]?>
              </div></td>
          <td valign="top" bgcolor="#FFFFFF"><div align="center"><span class="style4">
            <?=number_format($dbarrm["all_price"])?>
           
          </span>
          </div></td>
        </tr>
        <?
        }
        ?>
      </table>      
<table width="747" border="0" align="center">
        <tr>
          <td valign="top"><div align="right">รวมทั้งสิ้น
              <?=number_format($sum)?>
บาท </div></td>
        </tr>
</table>                                                                                                                                                         
      <p align="center">&nbsp;</p>
      <p align="center">
         <input onclick="javascript:window.print()" type="button" value="พิมพ์" />
         <input type="submit" name="Submit" value="กลับหน้าเดิม"onclick="window.location='report.php'"/>
</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
    <p>&nbsp;</p>      <p>&nbsp;</p></td>
  </tr>
</table>
</body>
</html>