Maison > Article > développement back-end > 更新字段异常
更新字段错误
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 />