select * from yd_article a left join yd_article_field b on (a.id=b.aid) where id= and isshow=1 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 'and isshow=1 limit 1' at line 1
- D:\ZKEYS\www\host051969\wwwroot\include\mysql.php on line 39
34.
$this->arrSql[] = $sql;
35.
if( $result = mysql_query($sql, $this->conn) ){
36.
return $result;
37.
}else{
38.
if(mysql_error()!=''){
39.
40.
syError("{$sql}<br />执行错误: " . mysql_error());
}else{
41.
return TRUE;
42.
}
43.
}
44.
}
- D:\ZKEYS\www\host051969\wwwroot\include\mysql.php on line 8
3.
class db_mysql {
4.
public $conn;
5.
public $arrSql;
6.
public function getArray($sql)
7.
{
8.
9.
if( ! $result = $this->exec($sql) )return array();
if( ! mysql_num_rows($result) )return array();
10.
$rows = array();
11.
while($rows[] = mysql_fetch_array($result,MYSQL_ASSOC)){}
12.
mysql_free_result($result);
13.
array_pop($rows);
- D:\ZKEYS\www\host051969\wwwroot\include\syModel.php on line 124
119.
return $this->update($conditions, array($field=>$value));
120.
}
121.
122.
public function findSql($sql)
123.
{
124.
125.
return $this->_db->getArray($sql);
}
126.
127.
public function runSql($sql)
128.
{
129.
return $this->_db->exec($sql);
- D:\ZKEYS\www\host051969\wwwroot\source\article.php on line 19
14.
if($this->syArgs('file',1)!=''){
15.
$this->article=syDB('article')->findSql('select * from '.$this->db.' a left join '.$this->db.'_field b on (a.id=b.aid) where (htmlfile="'.$this->syArgs('file',1).'" or id='.$this->syArgs('file').') and isshow=1 limit 1');
16.
$id = $this->article['id'];
17.
}else{
18.
$id = $this->syArgs('id');
19.
20.
$this->article=syDB('article')->findSql('select * from '.$this->db.' a left join '.$this->db.'_field b on (a.id=b.aid) where id='.$id.' and isshow=1 limit 1');
}
21.
if(!$this->article){message("指定内容不存在或未审核");}
22.
$this->article=$this->article[0];
23.
$this->article=array_merge($this->article,array('tid_leafid'=>$this->sy_class_type->leafid($this->article['tid'])));
24.
if($this->article['mrank']>0||$this->article['mgold']>0){
- D:\ZKEYS\www\host051969\wwwroot\include\Functions.php on line 16
11.
$handle_controller = syClass($__controller, null, $GLOBALS['G_WS']["controller_path"].'/'.$__controller.".php");
12.
if(!is_object($handle_controller) || !method_exists($handle_controller, $__action)){
13.
syError('route Error');
14.
exit;
15.
}
16.
17.
$handle_controller->$__action();
if(FALSE != $GLOBALS['G_WS']['view']['auto_display']){
18.
$__tplname = $__controller.$GLOBALS['G_WS']['view']['auto_display_sep'].
19.
$__action.$GLOBALS['G_WS']['view']['auto_display_suffix'];
20.
$handle_controller->auto_display($__tplname);
21.
}
- D:\ZKEYS\www\host051969\wwwroot\index.php on line 16
11.
}
12.
*/
13.
if($whosamConfig['ext']['close_site']=='1'){
14.
$whosamConfig['view']['config']['template_dir'] = APP_PATH.'/template/'.$whosamConfig['ext']['view_themes'];
15.
require(WHOSAM_PATH."/sys.php");
16.
17.
spRun();
}else{
18.
header("content-Type: text/html; charset=Utf-8");
19.
echo $whosamConfig['ext']['close_description'];
20.
}