select *,a.orders from dy_fangyuan a left join dy_fangyuan_field b on (a.id=b.aid) where b.office= and isshow=1 order by mianji asc limit 0,5
执行错误: 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 order by mianji asc limit 0,5' at line 1
- /www/wwwroot/scdcoffice/include/mysql.php on line 77
72.
public function __val_escape($value) {
73.
return '\''.$value.'\'';
74.
}
75.
76.
public function __destruct()
77.
78.
{
if( TRUE != $GLOBALS['G_DY']['db']['persistent'] )@mysql_close($this->conn);
79.
}
80.
}
81.
- /www/wwwroot/scdcoffice/include/mysql.php on line 15
10.
$rows = array();
11.
while($rows[] = mysql_fetch_array($result,MYSQL_ASSOC)){}
12.
mysql_free_result($result);
13.
array_pop($rows);
14.
return $rows;
15.
16.
}
17.
public function newinsertid()
18.
{
19.
return mysql_insert_id($this->conn);
20.
}
- /www/wwwroot/scdcoffice/include/syModel.php on line 247
242.
243.
}
244.
245.
class syPager {
246.
private $model_obj = null;
247.
248.
private $pageData = null;
private $input_args = null;
249.
public function __input(& $obj, $args){
250.
$this->model_obj = $obj;
251.
$this->input_args = $args;
252.
return $this;
- /www/wwwroot/scdcoffice/source/channel.php on line 484
479.
480.
if ($this->molds=="office")
481.
482.
{
483.
484.
485.
$this->fangyuan=syDB('fangyuan')->findSql('select *,a.orders from '.$this->dbfy.' a left join '.$this->dbfy.'_field b on (a.id=b.aid) where b.office='.$id.' and isshow=1 order by mianji asc limit 0,5');
486.
$fangyuan=$this->fangyuan;
487.
488.
foreach($fangyuan as $k=>$v){
489.
- /www/wwwroot/scdcoffice/include/Functions.php on line 31
26.
27.
exit;
28.
29.
}
30.
31.
32.
$handle_controller->$__action();
33.
if(FALSE != $GLOBALS['G_DY']['view']['auto_display']){
34.
35.
$__tplname = $__controller.$GLOBALS['G_DY']['view']['auto_display_sep'].
36.
- /www/wwwroot/scdcoffice/index.php on line 60
55.
56.
}
57.
58.
require(DOYO_PATH."/sys.php");
59.
60.
spRun();