Home  >  Article  >  Backend Development  >  更新字段异常

更新字段异常

WBOY
WBOYOriginal
2016-06-13 11:58:571029browse

更新字段错误
Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误。' in D:\Workspace\PHP\alalan\adminalila\InfoLi\list_px.php:12 Stack trace: #0 D:\Workspace\PHP\alalan\adminalila\InfoLi\list_px.php(12): com->Execute('update info set...') #1 {main} thrown in D:\Workspace\PHP\alalan\adminalila\InfoLi\list_px.php on line 12

<?php<br />	if(@$_REQUEST["top"]!=""){<br />		$top=@$_REQUEST["top"];<br />		if(is_numeric($top)){<br />			<br />			<span style="color: #FF0000;">$sqlcp="update info set top=".$top." where id=".$_REQUEST["id"];</span>			<span style="color: #FF0000;">$conn->Execute($sqlcp);</span><br />		}else{<br />			showmsg("字符不正确!只能输入数字!!","list_px.php?wz=".@$_REQUEST["wz"]."&page=".@$_REQUEST["page"]."");<br />		}<br />	}<br />?><br /><form name="form" method="post" action="?wz=<?php echo @$_REQUEST["wz"];?>&page=<?php echo @$_REQUEST["page"];?>">  <br />  <tr  bgcolor="<?php echo $bgc;?>" onMouseOut="this.className=''" onMouseOver="this.className='list-bg'"><br />    <td class="list1 pl8"> <a href="List_Edit.asp?checkbox=<?php $rf=$rs->fields("id");<br />	 echo $rf->value;<br />	?>&wz=<?php echo urlencode($wz);?>"><?php $rf=$rs->fields("title");echo $rf->value;?><?php $rf=$rs->fields("pic");if($rf->value!="") echo "<a href='../../upload3/".$rs["pic"]."'  target='_blank'><img src='../images/pic.gif'  border=0   alt='查看图片'/></a>";?></td><br /><br />	<br />    <td align="center" class="list1"><br />	<span   style="max-width:90%"><input name="top" class="listform" id="top" onBlur="javascript:this.form.submit();"  onClick="this.className='listform1'" value="<?php $rf=$rs->fields("top"); echo $rf->value;?>" maxlength="5" /><br />    <input type="hidden" name="id" value="<?php $rf=$rs->fields("id"); echo $rf->value;?>">	</td></span>	<br />	<br />	<br />    <td align="center" class="list1"><?php $rf=$rs->fields("hit"); echo $rf->value;?></td><br />    <td align="center" class="list1"><?php $rf=$rs->fields("wz"); echo $rf->value;?></td><br />    <td align="center" class="list1 pl8"><?php $rf=$rs->fields("postdate"); echo $rf->value;?></td><br />    </tr></form><br />

------解决方案--------------------
因为top是sql语句内置的单词 跟like、order差不多 当作字段用的话要加上`号 比如`top`=...
------解决方案--------------------
他不是提示说 sql 指令错了吗?
你打印出来看看

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn