<html> <style type='text/css'> table {border-collapse:collapse;} td {border:solid 1px #ddd;} </style> <body> <?php $link=mysql_connect("IP","User","Pwd"); if(!$link) echo "没有连接成功!"; else echo "连接成功!"; ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <label for="A">客户编号 </label> <input type="text" id="A" name="cust" /> <br /> <label for="B">客户订单号</label> <input type="text" id="B" name="cust_id" /> <input type="submit" name="submit" value="查询" /> </form> <?php if (isset($_POST['submit'])) { $cust = $_POST['cust']; $cust_id = $_POST['cust_id']; mysql_select_db("myoabird", $link); //选择数据库 $q = "SELECT a,b,a FROM c where a='$cust' or b='$cust_id'"; //SQL查询语句 mysql_query("SET NAMES GB2312"); $rs = mysql_query($q, $link); //获取数据集 if(!$rs){die("查无数据!");} echo "<table>"; echo "<tr><td>客户</td><td>客户订单号</td><td>订单数量</td></tr>"; while($row = mysql_fetch_row($rs)) echo "<tr><td>$row[0]</td><td>$row[1]</td><td>$row[2]</td></tr>"; //显示数据 echo "</table>"; mysql_free_result($rs); //关闭数据集 } ?> </body> </html>