多条件式查询语法整合

小弟最近做专题碰上瓶颈，想把两个范本的IF 整合，却找不到方法

1.--------------------------------------------- ------------------------------------------------

<code>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++;
}</code>

?>

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

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++;
    }
}

?>
想请问网友该怎么做?

                            
                        


                                                                                                                        
                     
回复内容：
                      
                                                            
小弟最近做专题碰上瓶颈，想把两个范本的IF 整合，却找不到方法
1.--------------------------------------------- ------------------------------------------------

<code>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++;
}</code>
?>

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

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++;
    }
}

?>
想请问网友该怎么做?

                            
                        
            

                                    
链式写法，因为面向对象特性，可以返回this
http://segmentfault.com/a/1190000003069921?utm_source=APP&utm_medium=iOS&utm_campaign=socialShare