select * from ld_product a left join ld_product_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
- /www/wwwroot/www.kejada.com/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.
}
- /www/wwwroot/www.kejada.com/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);
- /www/wwwroot/www.kejada.com/include/modelBase.php on line 129
124.
return $this->update($conditions, array($field=>$value));
125.
}
126.
127.
public function findSql($sql)
128.
{
129.
130.
return $this->_db->getArray($sql);
}
131.
132.
public function runSql($sql)
133.
{
134.
return $this->_db->exec($sql);
- /www/wwwroot/www.kejada.com/admin/product.php on line 24
19.
if($this->sysParams('file',1)!=''){
20.
$this->product=syDB('product')->findSql('select * from '.$this->db.' a left join '.$this->db.'_field b on (a.id=b.aid) where (htmlfile="'.$this->sysParams('file',1).'" or id='.$this->sysParams('file').') and isshow=1 limit 1');
21.
$id = $this->product['id'];
22.
}else{
23.
$id = $this->sysParams('id');
24.
25.
$this->product=syDB('product')->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');
}
26.
if(!$this->product){message("指定内容不存在或未审核");}
27.
$this->product=$this->product[0];
28.
29.
if($this->product['mrank']>0){
- /www/wwwroot/www.kejada.com/include/functions.php on line 18
13.
$handle_controller = syClass ( $__controller, null, $GLOBALS ['LD_I'] ["controller_path"] . '/' . $__controller . ".php" );
14.
if (! is_object ( $handle_controller ) || ! method_exists ( $handle_controller, $__action )) {
15.
syError ( 'route Error' );
16.
exit ();
17.
}
18.
19.
$handle_controller->$__action ();
if (FALSE != $GLOBALS ['LD_I'] ['view'] ['auto_display']) {
20.
$__tplname = $__controller . $GLOBALS ['LD_I'] ['view'] ['auto_display_sep'] . $__action . $GLOBALS ['LD_I'] ['view'] ['auto_display_suffix'];
21.
$handle_controller->auto_display ( $__tplname );
22.
}
23.
spLaunch ( "router_postfilter" );
- /www/wwwroot/www.kejada.com/index.php on line 24
19.
$idxwap = isset($_GET['wap'])?$_GET['wap']=='wap'?'wap/':'':'';
20.
define('_WAPTEMPLATE_',$idxwap);
21.
$iConfig['view']['config']['template_dir'] = APP_PATH.'/template/'.$iConfig['ext']['view_themes'];
22.
23.
require(I_PATH."/app.php");
24.
appRun();