SELECT id,style,mrank,mgold,title,htmlurl,htmlfile FROM dy_sales WHERE id< and tid in() ORDER BY id desc 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 tid in() ORDER BY id desc LIMIT 1' 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 109
104.
$where = "WHERE ( ".join(" AND ",$join). ")";
105.
}else{
106.
if(null != $conditions)$where = "WHERE ( ".$conditions. ")";
107.
}
108.
$sql = "DELETE FROM {$this->tbl_name} {$where}";
109.
110.
return $this->_db->exec($sql);
}
111.
112.
public function findBy($field, $value)
113.
{
114.
return $this->find(array($field=>$value));
- /www/wwwroot/scdcoffice/include/syModel.php on line 53
48.
if(null != $sort){
49.
$sort = "ORDER BY {$sort}";
50.
}else{
51.
$sort = "ORDER BY {$this->pk}";
52.
}
53.
54.
$sql = "SELECT {$fields} FROM {$this->tbl_name} {$where} {$sort}";
if(null != $limit)$sql = $this->_db->setlimit($sql, $limit);
55.
return $this->_db->getArray($sql);
56.
}
57.
58.
public function escape($value)
- /www/wwwroot/scdcoffice/source/channel.php on line 507
502.
503.
$prev_next_w=' and tid in('.$this->sy_class_type->leafid($this->channel['tid']).') ';
504.
505.
$prev_next_f='id,style,mrank,mgold,title,htmlurl,htmlfile';
506.
507.
508.
$prev=syDB($this->molds)->find(' id<'.$this->channel['id'].$prev_next_w,'id desc',$prev_next_f);
509.
if($prev){
510.
511.
$prev['url']=html_url('channel',$prev,0,'',$this->molds);
512.
- /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();