error>>>>Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\bookroom\searchmemberregis.php on line 138
line 138 อยู่ตรงไหนครับ
Date :
2011-02-19 23:33:52By :
PlaKriM
Code (PHP) <?
}
$goto=($page-1)*$item;
$scer=$_POST[secr];
if(!empty($scer)){
$sql = "select * from br_user where fname LIKE '%$scer%' order by id desc limit $goto,$item ";
}else{
$sql="select * from br_user order by id name desc limit $goto,$item";
}
$result=mysql_query($sql);
$m=$goto;
while ($fetchrr=mysql_fetch_array($result)){ <<<error ตรงนี้ครับช่วยดูหน่อยครับ
++$m;
?>
Date :
2011-02-19 23:42:39By :
bankchan
line 135 ครับที่ มันฟ้อง errorCode (PHP) <?php
session_start();
?>
<?php
include 'connect.php';
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<TITLE>โปรแกรมจองห้องประชุม</TITLE>
<? if($level!='9'){
?>
<SCRIPT language="JavaScript">
alert("กรุณาติดต่อเจ้าหน้าที่");
location.href='index.php';
</SCRIPT>
<? } ?>
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
}
-->
</style>
<link href="stylesheet.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#CCCCCC"><? if($level=='0'){ ?>
<table width="300" border="0" align="right" cellpadding="5" cellspacing="0">
<tr class="unnamed1">
<td><div align="center"></div></td>
<td class="unnamed1"><div align="center"><a href="s">จองห้องประชุม</a></div></td>
<td class="unnamed1"><div align="center"><a href="login.php">ออกจากระบบ</a></div></td>
</tr>
</table>
<? } ?>
<? if($level=='9'){ ?>
<table width="700" border="0" align="center" cellpadding="5" cellspacing="0">
<tr class="unnamed1">
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' "><div align="left"><a href="user.php">กำหนดผู้ใช้ระบบ</a></div></td>
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' " class="unnamed1"><div align="left"><a href="position.php">กำหนดตำแหน่ง</a></div></td>
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' " class="unnamed1"><div align="left"><a href="depart.php">กำหนดแผนก</a></div></td>
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' " class="unnamed1"><div align="left"><a href="room.php">กำหนดห้องประชุม</a></div></td>
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' " class="unnamed1"><div align="left"><a href="sod.php">กำหนดอุปกรณ์เสริม</a></div></td>
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' " class="unnamed1"><div align="center"><a href="time.php">กำหนดช่วงเวลา</a></div></td>
</tr>
<tr class="unnamed1">
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' "><div align="left"><a href="anumat.php">กำหนดการอนุมัติ</a></div></td>
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' "><div align="left"><a href="editjonroom.php">แก้ไขข้อมูลการจองห้อง</a></div></td>
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' "><div align="left"><a href="checkanumat.php">ตรวจสอบการขอใช้ห้อง</a></div></td>
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' "><div align="left"><a href="jonroom.php">จองห้องประชุม</a></div></td>
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' "><div align="left"><a href="jonday.php">กำหนดวันจองล่วงหน้า</a></div></td>
<td onMouseover="this.style.backgroundColor ='#ffffff'" onMouseOut="this.style.backgroundColor='#cccccc' " class="unnamed1"><a href="login.php">ออกจากระบบ</a></td>
</tr>
</table>
<? } ?></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td bgcolor="#EFEFEF" class=" unnamed1"><strong class="boxtitle1"> ค้นหาข้อมูลผุ้ใช้</strong></td>
</tr>
</table>
<br>
<?
$sql="select * from br_user";
$result=mysql_query($sql) or die (mysql_error());
$numrows=mysql_num_rows($result);
$item=10;
$pagelen=ceil($numrows/$item);
if(!isset($_GET['page'])){
$page=1;
}else{
$page=$_GET['page'];
}
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
<td align="right"><form id="form1" name="form1" method="post" action="searchmemberregis.php?key=<? echo "$key"; ?>" onChange="document.form1.submit();">
<span class="style11" style="font-weight: bold">ค้นหาชื่อ</span><span class="style11">:
<label>
<input type="text" name="secr" id="secr" />
</label>
</span><span class="style9"><label> </label>
</span>
<label> </label>
</form> </td>
</tr>
</table></td>
</tr>
<tr>
<td><span class="style2">หน้า:
<?
for($i=1;$i<=$pagelen;$i++){
if($i==$page){
echo "<a href='searchmemberregis.php?key=$key&page=$i'>[ $i ]</a>\t";
}else{
echo "<a href='searchmemberregis.php?key=$key&page=$i'> [ $i ]</a>\t";
}
}
?>
</span></td>
<td align="right"> </td>
</tr>
<tr>
<td colspan="2"><?
// echo " จำนวนรายการที่มีอยู่ $numrows";
if($numrows>0){//เช็กให้มันโชว์table ถ้ามีค่าอยู่
?>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#003300">
<tr>
<td width="15%" bordercolor="#FF0033" bgcolor="#FF0066"><div align="center" class="style3"><strong>Username</div></td>
<td width="15%" bordercolor="#FF0033" bgcolor="#FF0066"><div align="center" class="style4"><strong>Passwords</strong></div></td>
<td width="20%" bordercolor="#FF0033" bgcolor="#FF0066"><div align="center" class="style4"><strong>ชื่อ-นามสกุล</strong></div></td>
</tr>
<?
}
$goto=($page-1)*$item;
$scer=$_POST[secr];
if(!empty($scer)){
$sql = "select * from br_user where fname LIKE '%$scer%' order by id desc limit $goto,$item ";
}else{
$sql="select * from br_user order by id name desc limit $goto,$item";
}
$result=mysql_query($sql);
$m=$goto;
while ($fetchrr=mysql_fetch_array($result)){ <<<< ตรงนี้ครับที่ Error
++$m;
?>
<tr>
<td bordercolor="#FF0066" bgcolor="#FFFFFF"><span class="style8"><? echo $fetchrr['username'];?></span></td>
<td bordercolor="#FF0066" bgcolor="#FFFFFF"><span class="style8"><? echo $fetchrr['passwords'];?></span></td>
<td bordercolor="#FF0066" bgcolor="#FFFFFF"><span class="style8"><? echo $fetchrr['fname'];?></span></td>
</tr>
<?
}
?>
</table>
</html>
Date :
2011-02-19 23:44:19By :
bankchan
debug ดูนะครับCode (PHP) <?
}
$goto=($page-1)*$item;
$scer=$_POST[secr];
if(!empty($scer)){
$sql = "select * from br_user where fname LIKE '%$scer%' order by id desc limit $goto,$item ";
}else{
$sql="select * from br_user order by id name desc limit $goto,$item";
}
$result=mysql_query($sql) or die(mysql_error() . "<br />" . $sql);
$m=$goto;
while ($fetchrr=mysql_fetch_array($result)){ <<<error ตรงนี้ครับช่วยดูหน่อยครับ
++$m;
?>
Date :
2011-02-19 23:47:30By :
PlaKriM
$result=mysql_query($sql) or die (mysql_error());
Date :
2011-02-19 23:56:28By :
bankchan
<<<< ตรงนี้ครับที่ Error เอาออกหรือยังครับ
Date :
2011-02-19 23:59:39By :
PlaKriM
ฟ้อง error เหมือนเดิมครับ
Date :
2011-02-20 00:03:32By :
bankchan
line 133
Date :
2011-02-20 00:24:54By :
PlaKriM
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 'name desc limit 0,10' at line 1
Date :
2011-02-20 00:28:55By :
bankchan
ผิดid name desc limit $goto,$item";
Date :
2011-02-20 01:07:59By :
PlaKriM
ได้แล้วครับ
Date :
2011-02-20 01:57:45By :
bankchan
Server 05
Load balance : Server 05
