Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\pro_shuy\teach_order.php on line 135
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
โค้ด: เลือกทั้งหมด
<?php
session_start() ;
if (!isset($_SESSION['sess_user'])) {
header("Location: index.php");
exit;
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<?
include "title.php";
?>
<link rel="stylesheet" href="css/reset.css" type="text/css" media="screen">
<link rel="stylesheet" href="css/style.css" type="text/css" media="screen">
<link rel="stylesheet" href="css/grid.css" type="text/css" media="screen">
<script src="js/jquery-1.7.1.min.js"></script>
<script src="js/Vegur_500.font.js"></script>
<script src="js/Ropa_Sans_400.font.js"></script>
<script src="js/FF-cash.js"></script>
<script src="js/tms-0.3.js"></script>
<script src="js/tms_presets.js"></script>
<script src="js/jquery.easing.1.3.js"></script>
<script src="js/script.js"></script>
<!--[if lt IE 9]>
<script src="js/html5.js"></script>
<link rel="stylesheet" href="css/ie.css" type="text/css" media="screen">
<![endif]-->
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<style type="text/css">
<!--
.style40 {color: #FFFFFF}
.style41 {color: #333333}
-->
</style>
</head>
<body id="page1">
<!--==============================header=================================-->
<header>
<? include "menu_teach.php"; ?>
<div class="row-bot"></div>
</header>
<!--==============================content================================-->
<section id="content">
<div class="main">
<div class="container_12">
<div class="wrapper">
<article class="grid_8">
<h4>รายการยืม</h4>
<form action="member_order.php" method="post" name="form2" id="form2">
<table width="620" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" bordercolordark="#ffffff">
<tr>
<td height="37" align="center" valign="middle" bgcolor="#333333" class="style25"><span class="style40">ค้นหาเลขที่</span>
<label>
<input name="keyword" type="text" id="keyword" />
</label>
<label></label>
<label>
<input name="Submit" type="submit" class="style25" value="ค้นหา" />
</label></td>
</tr>
</table>
<br />
</form>
<table width="620" height="52" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#333333" bordercolordark="#FFFFFF">
<tr align="center" bgcolor="#EBEBEB" class="style23">
<td width="70" height="43" valign="middle" bgcolor="#999999" class="style41">เลขที่</td>
<td width="123" valign="middle" bgcolor="#999999" class="style41">วันที่</td>
<td width="232" valign="middle" bgcolor="#999999" class="style41">สมาชิก</td>
<td width="75" valign="middle" bgcolor="#999999" class="style41">การยืนยัน</td>
</tr>
</table>
<?
$keyword=$_POST['keyword'];
if($keyword==""){
$keyword="";
}
include "connect.php";
$tb="orders";
$sql = "select * From $tb where serial like '%$keyword%' and order2 ='0' and user ='$sess_user' order by serial desc ";
/* ตั้งค่า แสดงผลต่อหน้า $Per_Page */
$Per_Page =15; // แสดงหน้าละ 12
if(!$Page)
$Page=1;
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$result = mysql_query($sql);
$Page_start = ($Per_Page*$Page)-$Per_Page;
$Num_Rows = mysql_num_rows($result);
if($Num_Rows<=$Per_Page)
$Num_Pages =1;
else if(($Num_Rows % $Per_Page)==0)
$Num_Pages =($Num_Rows/$Per_Page) ;
else
$Num_Pages =($Num_Rows/$Per_Page) +1;
$Num_Pages = (int)$Num_Pages;
if(($Page>$Num_Pages) || ($Page<0))
print "<center><b>จำนวน $Page มากกว่า $Num_Pages ยังไม่มีข้อความ<b></center>";
$sql = "select * From $tb where serial like '%$keyword%' and order2 ='0' and user ='$sess_user' order by serial desc LIMIT $Page_start , $Per_Page";
//ส่วนแสดงผล
$result = mysql_query($sql);
While($row= mysql_fetch_array($result)){
$idbill = $row["serial"];
$date= $row["date"];
$customerid= $row["customerid"];
$sale= $row["sale"];
$order= $row["order"];
$bgcount=$bgcount+1;
$bgmod=$bgcount%2;
if($bgmod==0){
$bgcolor="#FFFFFF";
}else{
$bgcolor="#FFFFCC";
}
?>
<table width="620" height="40" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#333333" bordercolordark="#FFFFFF">
<tr bgcolor="<? echo "$bgcolor"; ?>">
<td width="70" align="center" valign="middle" class="style25"><a href='view_order.php?action=view&idbill=<?=$idbill?>' target="_blank"><? echo "$idbill";?></a></td>
<td width="123" align="center" valign="middle" class="style25"><?
echo "$date";
?></td>
<td width="232" align="center" valign="middle" class="style25"><?
$tb1="customers";
$sql1="select * from $tb1 where serial=$customrid";
$db_query1=mysql_db_query($db,$sql1).($sql_select);
$result1=mysql_fetch_array($db_query1).($sql_select);
if(!$db_query1){ echo mysql_error(); }
$prd_name=$result1['name'];
$prd_num=$result1['phone'];
echo $prd_name;
?></td>
<td width="75" align="center" valign="middle" class="style25"><span class="style25 style40">
<? if($sale=="1"){
echo "<font color=blue>เรียบร้อย</font>"; }else{echo "<font color =red>รอการยืนยัน</font>";} ?>
</span></td>
</tr>
</table>
<?
}
?>
<center>
<p><span class="style25">พบทั้งหมด<b>
<?= $Num_Rows;?>
</b> รายการ รวมทั้งหมด : <b>
<?=$Num_Pages;?>
</b> หน้า :
<?/* สร้างปุ่มย้อนกลับ */
if($Prev_Page)
echo " <a href='$PHP_SELF?Page=$Prev_Page&class=$keyword'><< ย้อนกลับ </a>";
for($i=1; $i<$Num_Pages; $i++){
if($i != $Page)
echo "[<a href='$PHP_SELF?Page=$i&class=$keyword'>$i</a>]";
else
echo "<b> $i </b>";
}
/*สร้างปุ่มเดินหน้า */
if($Page!=$Num_Pages)
echo "<a href ='$PHP_SELF?Page=$Next_Page&class=$keyword'> หน้าถัดไป>> </a></center>";
mysql_close();
?>
</span></p>
<p class="p2"> </p>
</center>
</article>
<? include "side_teach.php";?>
</div>
</div>
</div>
</section>
<!--==============================footer=================================-->
<? include "footer.php";?>
</body>
</html>
โค้ด: เลือกทั้งหมด
<td width="232" align="center" valign="middle" class="style25"><?
$tb1="customers";
$sql1="select * from $tb1 where serial=$customrid";
$db_query1=mysql_db_query($db,$sql1).($sql_select);
$result1=mysql_fetch_array($db_query1).($sql_select);
if(!$db_query1){ echo mysql_error(); }
$prd_name=$result1['name'];
$prd_num=$result1['phone'];
echo $prd_name;
?></td>