select id,tid,sid,title,style,trait,gourl,addtime,hits,htmlurl,htmlfile,litpic,orders,mrank,mgold,isshow,keywords,description,cxziduan,worduotu,zailaidtu,xinzi,zhize,zige,mioashu,jianjie,biaoqian from lz_article a left join lz_article_field b on (a.id=b.aid) where isshow=1 and tid in() order by orders desc,addtime desc,id desc limit 100
执行错误: 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,addtime desc,id desc limit 100' at line 1
- /www/wwwroot/new.sellergrowth.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/new.sellergrowth.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/new.sellergrowth.com/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);
- /www/wwwroot/new.sellergrowth.com/include/cache/tpl/product_Rbiao_show.php on line 527
522.
<div class="blank0"></div>
523.
<div class="vat_show_xq_nrbt" id="renzheng1">
524.
<h3>常见问题</h3>
525.
</div>
526.
<div class="vat_zhuce_sideMenu" style="margin:0 auto">
527.
528.
<?php $gedyid=$product['dyid'] ?> <?php $vn=0;$tablev=syClass("syModel")->findSql("select id,tid,sid,title,style,trait,gourl,addtime,hits,htmlurl,htmlfile,litpic,orders,mrank,mgold,isshow,keywords,description,cxziduan,worduotu,zailaidtu,xinzi,zhize,zige,mioashu,jianjie,biaoqian from lz_article a left join lz_article_field b on (a.id=b.aid) where isshow=1 and tid in(".$gedyid.") order by orders desc,addtime desc,id desc limit 100");foreach($tablev as $v){ $v["tid_leafid"]=$sy_class_type->leafid($v["tid"]);$v["n"]=$vn=$vn+1; $v["url"]=html_url("article",$v); $v["title"]=stripslashes($v["title"]); $v["description"]=stripslashes($v["description"]); ?>
<h3><em></em><?php echo $v['title'] ?></h3>
529.
<ul>
530.
<p>
531.
<?php echo cutstr_html(bodyinfo('article_field',$v['id'],'body')) ?></p>
532.
</ul>
- /www/wwwroot/new.sellergrowth.com/include/Template.php on line 89
84.
if( $enable_gzip==1 ){
85.
GLOBAL $__template_compression_level;
86.
$__template_compression_level=syExt('enable_gzip_level');
87.
ob_start('template_ob_gzip');
88.
}
89.
90.
include $template_tpl;
}
91.
92.
private function template_html($content){
93.
preg_match_all('/\{include=\"(.*?)\"\}/si',$content,$i);
94.
foreach($i[0] as $k=>$v){
- /www/wwwroot/new.sellergrowth.com/include/syView.php on line 28
23.
{
24.
try {
25.
$this->addfuncs();
26.
$this->displayed = TRUE;
27.
if($GLOBALS['G_DY']['view']['debugging'] && SP_DEBUG)$this->engine->debugging = TRUE;
28.
29.
$this->engine->display($tplname);
} catch (Exception $e) {
30.
syError( $GLOBALS['G_DY']['view']['engine_name']. ' Error: '.$e->getMessage() );
31.
}
32.
}
33.
- /www/wwwroot/new.sellergrowth.com/include/syController.php on line 30
25.
26.
public function display($tplname, $output = TRUE)
27.
{
28.
@ob_start();
29.
if(TRUE == $GLOBALS['G_DY']['view']['enabled']){
30.
31.
$this->v->display($tplname);
}else{
32.
extract($this->__template_vals);
33.
require($tplname);
34.
}
35.
if( TRUE != $output )return ob_get_clean();
- /www/wwwroot/new.sellergrowth.com/source/product.php on line 134
129.
$type_pos=$this->sy_class_type->navi($tid);
130.
foreach($type_pos as $v){
131.
$d_pos=syDB('classtype')->find(array('tid'=>$v['tid']),null,'tid,molds,htmldir,htmlfile,mrank');
132.
$this->positions.=' > <a href="'.html_url('classtype',$d_pos).'">'.$v['classname'].'</a>';
133.
}
134.
135.
$this->display('product/'.$t);
}
136.
function hits(){
137.
if($this->syArgs('id')){
138.
syDB('product')->incrField(array('id'=>$this->syArgs('id')), 'hits');
139.
$hits=syDB('product')->find(array('id'=>$this->syArgs('id')),null,'hits');
- /www/wwwroot/new.sellergrowth.com/include/Functions.php on line 16
11.
$handle_controller = syClass($__controller, null, $GLOBALS['G_DY']["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_DY']['view']['auto_display']){
18.
$__tplname = $__controller.$GLOBALS['G_DY']['view']['auto_display_sep'].
19.
$__action.$GLOBALS['G_DY']['view']['auto_display_suffix'];
20.
$handle_controller->auto_display($__tplname);
21.
}
- /www/wwwroot/new.sellergrowth.com/index.php on line 5
1.
<?php
2.
require("config.php");
3.
$lzConfig['view']['config']['template_dir'] = APP_FILEOS.'/template/'.$lzConfig['ext']['view_themes'];
4.
require(LZVN_PATH."/sys.php");
5.
6.
spRun();
7.
//$url='/article/type/114-1.html';
8.
//$content = file_get_contents($url);
9.
////����� fetch() ���ǻ�ȡ������ݵĺ���,����$content��������,����Ҫ��ʾ��������
10.
//$fp = fopen("sitemap.htm", "w");