? SELECT id,title FROM yt_article WHERE id > '21010' and cat_id= ORDER BY id asc LIMIT 1<br>执行错误: 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 'ORDER BY id asc LIMIT 1' at line 1 亚博平台娱乐怎样,yabo官网,亚博手机网页版

SELECT id,title FROM yt_article WHERE id > '21010' and cat_id= ORDER BY id asc LIMIT 1
执行错误: 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 'ORDER BY id asc LIMIT 1' at line 1

57.? ????{
58.? ????????$this->arrSql[]?=?$sql;
59.? ????????if(?$result?=?mysql_query($sql,?$this->conn)?){
60.? ????????????return?$result;
61.? ????????}else{
62.? ????????????spError("{$sql}执行错误:?"?.?mysql_error());
63.? ????????}
64.? ????}
65.? ????
66.? ????/**
67.? ?????*?返回影响行数
21.? ?????*?
22.? ?????*?@param?sql??执行的SQL语句
23.? ?????*/
24.? ????public?function?getArray($sql)
25.? ????{
26.? ????????if(?!?$result?=?$this->exec($sql)?)return?array();
27.? ????????if(?!?mysql_num_rows($result)?)return?array();
28.? ????????$rows?=?array();
29.? ????????while($rows[]?=?mysql_fetch_array($result,MYSQL_ASSOC)){}
30.? ????????mysql_free_result($result);
31.? ????????array_pop($rows);
98.? ????????}else{
99.? ????????????$sort?=?"ORDER?BY?{$this->pk}";
100.? ????????}
101.? ????????$sql?=?"SELECT?{$fields}?FROM?{$this->tbl_name}?{$where}?{$sort}";
102.? ????????if(null?!=?$limit)$sql?=?$this->_db->setlimit($sql,?$limit);
103.? ????????return?$this->_db->getArray($sql);
104.? ????}
105.? ????/**
106.? ?????*?过滤转义字符
107.? ?????*
108.? ?????*?@param?value?需要进行过滤的值
219.? ????????????@$article_result['ad_url']?=?$ad_dir_arr[1];
220.?
221.? ????????????$this->article_result?=?$article_result;
222.? ????????????if(!$article_result)?$this->jump(spUrl('main',?'index'));
223.? ????????????//查找上下文信息
224.? ????????????$article_pre?=?$article->findAll("id?>?'".$data['article_id']."'?and?cat_id=?".$article_result['cat_id'],"id?asc","id,title",1);
225.? ????????????$article_aft?=?$article->findAll("id?.$data['article_id']."'?and?cat_id=?".$article_result['cat_id'],"id?desc","id,title",1);
226.? ????????????$this->article_pre?=?$article_pre[0];
227.? ????????????$this->article_aft?=?$article_aft[0];
228.? ????????????//增加阅读数
229.? ????????????$article->update('id='.$data['article_id'],?array('view_num'=>$article_result['view_num']+1,'add_time'=>$article_result['add_time']));
16.? ????if(!is_object($handle_controller)?||?!method_exists($handle_controller,?$__action)){
17.? ????????eval($GLOBALS['G_SP']["dispatcher_error"]);
18.? ????????exit;
19.? ????}
20.? ????//?路由并执行用户代码
21.? ????$handle_controller->$__action();
22.? ????//?控制器程序运行完毕,进行模板的自动输出
23.? ????if(FALSE?!=?$GLOBALS['G_SP']['view']['auto_display']){
24.? ????????$__tplname?=?$__controller.$GLOBALS['G_SP']['view']['auto_display_sep'].
25.? ????????????????$__action.$GLOBALS['G_SP']['view']['auto_display_suffix'];?//?拼装模板路径
26.? ????????$handle_controller->auto_display($__tplname);
41.? import(APP_PATH.'/include/thFunctions.php');?//smarty自写函数?
42.?
43.? import(APP_PATH.'/controller/top.php');?//TOP全局控制器?
44.?
45.? header("Content-type:?text/html;?charset=utf-8");?
46.? spRun();
47.?