我有兩個PHP黨，一個是historyorder.php輸入查詢訂單資料，另一個是test.php接收資料並執行php顯示資料，查詢總額跟姓名可以，為什麼我可以查兩個購買時間日期範圍內卻不能查兩個編號內範圍，我的處理時間兩個範圍內也不行會顯示無此資料 我是依兩個購買時間範圍內這個可以的去修改，可以請教一下怎麼修改嗎 我的時間戳記是年月日時分秒

歷史訂單查詢資料庫
資料庫goodsapp
資料表orders幾個欄位
orderid 訂單編號
name 姓名
ordertime 購買時間
totalmoney 總額
chargetime 處理時間

historyorder.php

輸入購買時間
 <form action="test.php" method="Post">
 日期:
 <input type="Text" name="ordertime">
 至日期:
  <input type="Text" name="ordertime2">
或總金額:
  <input type="Text" name="totalmoney">
 訂單編號:
  <input type="Text" name="orderid">
  至編號:
  <input type="Text" name="orderid2">
 姓名:
  <input type="Text" name="name">
  處理時間:
  日期
  <input type="Text" name="chargetime">
   至日期:
  <input type="Text" name="chargetime2">
  
  

 <input type="Submit"value='查詢'>
 
 </form>

test.php

<?php   
	header("Content-Type: text/html; charset=utf-8");
	include("connsql.php");  //連結資料庫檔案
	$seldb = @mysql_select_db("goodsapp");  //連結資料庫
	if (!$seldb) die("資料庫選擇失敗！");
  
  mysql_query("SET NAMES 'utf8'");
  $ordertime = '';
  $ordertime2 = '';
  $totalmoney = '';
  $orderid = '';
  $orderid2 = '';
  $name = '';
  $chargetime = '';
  $chargetime2 = '';

  if (isset($_POST['ordertime'])) {
    $ordertime = $_POST['ordertime'];
  }
  if (isset($_POST['ordertime2'])) {
    $ordertime2 = $_POST['ordertime2'];
  }
  if (isset($_POST['totalmoney'])) {
    $totalmoney = $_POST['totalmoney'];
  }
   if (isset($_POST['orderid'])) {
    $orderid = $_POST['orderid'];
  }
    if (isset($_POST['orderid2'])) {
    $orderid2 = $_POST['orderid2'];
  }
     if (isset($_POST['name'])) {
    $name = $_POST['name'];
  }
       if (isset($_POST['chargetime'])) {
    $chargetime = $_POST['chargetime'];
  }
       if (isset($_POST['chargetime2'])) {
    $chargetime2 = $_POST['chargetime2'];
  }
  if ($ordertime !== '' AND $ordertime2 !== '' And $totalmoney !== '') {
    $sql = "SELECT * FROM orders WHERE ordertime BETWEEN '$ordertime' AND '$ordertime2' AND totalmoney = '$totalmoney' ORDER BY ordertime DESC";    
  } else if ($ordertime !== '' AND $ordertime2 !== '') {
    $sql = "SELECT * FROM orders WHERE ordertime BETWEEN '$ordertime' AND '$ordertime2' ORDER BY ordertime DESC";  
  } else if ($totalmoney !== '') {
    $sql = "SELECT * FROM orders WHERE totalmoney = '$totalmoney' ORDER BY ordertime DESC";   
  } else if ($orderid !== '') {
    $sql = "SELECT * FROM orders WHERE orderid = '$orderid' ";
  }  else if ($orderid !== '' AND $orderid2 !== '') {
    $sql = "SELECT * FROM orders WHERE orderid BETWEEN '$orderid' AND '$orderid2' ORDER BY orderid DESC"; 
  } else if ($name !== '') {
    $sql = "SELECT * FROM orders WHERE name = '$name' ";   	
 } else if ($chargetime !== '') {
    $sql = "SELECT * FROM orders WHERE chargetime = '$chargetime' ";
 } else if ($chargetime !== '' AND $chargetime2 !== '') {
    $sql = "SELECT * FROM orders WHERE chargetime BETWEEN '$chargetime' AND '$chargetime2' ORDER BY chargetime DESC";   		
 }else 
  {
    $sql = "SELECT * FROM orders ORDER BY ordertime DESC";  
  }

  $result = mysql_query($sql) or die('MySQL query error');
  if (mysql_num_rows($result)) {
    echo "<table border = '1'>";
    echo "<tr>";
    echo "<th>訂單編號</th>";
	echo "<th>姓名</th>";
    echo "<th>訂購時間</th>";
    echo "<th>總額</th>";
	echo "<th>處理時間</th>";
    echo "</tr>";
    while($row = mysql_fetch_array($result))
    {
      echo "<tr>";
	  echo "<td>".$row['orderid']."</td>";
	  echo "<td>".$row['name']."</td>";
      echo "<td>".$row['ordertime']."</td>";
      echo "<td>".$row['totalmoney']."</td>";
	  echo "<td>".$row['chargetime']."</td>";
      echo "</tr>";
    }
    echo "</table>";
  } else {
    echo "查無資料";
  }
?>