SELECT * FROM dy_classtype WHERE molds='article' and tid= ORDER BY orders desc LIMIT 1
執(zhí)行錯(cuò)誤: 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 orders desc LIMIT 1' at line 1
- D:\wwwroot\www.mnfny.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 />執(zhí)行錯(cuò)誤: " . mysql_error());
}else{
41.
return TRUE;
42.
}
43.
}
44.
}
- D:\wwwroot\www.mnfny.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);
- D:\wwwroot\www.mnfny.com\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));
- D:\wwwroot\www.mnfny.com\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)
- D:\wwwroot\www.mnfny.com\include\Functions.php on line 77
72.
73.
}
74.
75.
76.
77.
78.
$handle_controller->$__action();
79.
80.
81.
if (FALSE != $GLOBALS['G_DY']['view']['auto_display']) {
82.
- D:\wwwroot\www.mnfny.com\index.php on line 48
43.
44.
$found_mobile=CheckSubstrs($mobile_os_list,$useragent_commentsblock) || CheckSubstrs($mobile_token_list,$useragent);
45.
46.
47.
48.
spRun();