多條件式查詢語法整合

Question

多條件式查詢語法整合

j31155662

211

发布于
2015-11-22

新手上路，请多包涵

小弟最近做專題碰上瓶頸，想把兩個範本的IF 整合，卻找不到方法

1.---------------------------------------------------------------------------------------------
<?php

header("Content-Type: text/html; charset=utf-8");
include("connsql.php");  //含入連結資料庫檔案
$seldb = @mysql_select_db("orderdrink");  //連結資料庫
if (!$seldb) die("資料庫選擇失敗！");

$sql_query = "SELECT `orderid`,`phone`,`name` FROM `orders` WHERE `finish`=0 ORDER BY `orderid` DESC";
$result = mysql_query($sql_query);
$numrow = mysql_num_rows($result);
$row_result = array();
$i = 0;
while($row_result[$i] = mysql_fetch_array($result, MYSQL_ASSOC)){
    $i++;
}

?>

2.--------------------------------------------------------------------------------------------

<?php

header("Content-Type: text/html; charset=utf-8");
include("connsql.php");  //含入連結資料庫檔案
$seldb = @mysql_select_db("orderdrink");  //連結資料庫
if (!$seldb) die("資料庫選擇失敗！");

if (isset($_GET["update"])) {
    $order = $_GET["update"];
    $sql_query = "UPDATE `orders` SET `finish`=1 WHERE `orderid`='" . $order . "'";
    $result = mysql_query($sql_query);
    header("Location: index.php");
}

$row_detail = array();
$order = $_GET["order"];
$sql_query = "SELECT * FROM `orders` WHERE `orderid`='" . $order . "'";
$result = mysql_query($sql_query);
$numorder = 0;
$numorder = mysql_num_rows($result);
if($numorder>0) {
    $row_order = mysql_fetch_array($result, MYSQL_ASSOC);
    $sql_query = "SELECT * FROM `productdetail` WHERE `orderid`='" . $order . "'";
    $result = mysql_query($sql_query);
    $numdetail = mysql_num_rows($result);
    $i = 0;
    while($row_detail[$i] = mysql_fetch_array($result, MYSQL_ASSOC)) {
        $i++;
    }
}