select * from pro_type where pro_type_p = order by pro_type_sore <> 0 desc,pro_type_sore asc
执行错误: 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 pro_type_sore <> 0 desc,pro_type_sore asc' at line 1

123.? ????}
124.? }
125.?
51.? ?????*?格式化带limit的SQL语句
52.? ?????*/
53.? ????public?function?setlimit($sql,?$limit)
54.? ????{
55.? ????????return?$sql.?"?LIMIT?{$limit}";
56.? ????}
57.?
58.? ????/**
59.? ?????*?执行一个SQL语句
60.? ?????*?
61.? ?????*?@param?sql?需要执行的SQL语句
406.? ????????}
407.? ????}
408.? ????/**?
409.? ?????*?获取分页数据
410.? ?????*/
411.? ????public?function?getPager(){
412.? ????????$tmppageData?=?$this->pageData;
413.? ????????$this->pageData?=?null;
414.? ????????return?$tmppageData;
415.? ????}
416.? ????
219.? ????????

echo?str_replace("../files/attached","files/attached",$result6_1['pro_type_des']);??>


220.? ????????<div?class="main_right_product">
221.? ????????????<ul>
222.? ???????????? 223.? ????????????$sql6='select?*?from?pro_type?where?pro_type_p?=?'.$id.'?order?by?pro_type_sore?<>?0?desc,pro_type_sore?asc';
224.? ????????????$result6?=?$pro_type->findsql($sql6);
225.? ????????????foreach($result6?as?$key=>$value)
226.? ????????????{
227.? ????????????????echo?"
  • <>
  • .str_replace("../uploads","uploads",$value['pro_type_img'])."\"?title=\"{$value['pro_type_name']}\"?/>{$value['pro_type_name']}";
    228.? ????????????}
    229.? ?????????????>
    4.? ????function?__construct()?{
    5.? ???????//自动执行父类构造函数
    6.? ????????parent::__construct();
    7.? ????????global?$__action;
    8.? ????????if(is_file(APP_PATH.'/action/act_'.$__action.'.php')){
    9.? ????????????require(APP_PATH.'/action/act_'.$__action.'.php');
    10.? ????????}
    11.? ????????/*else{
    12.? ??????????????if($__action?==?'index')
    13.? ??????????????????$this->display('index.html');
    14.? ????????}*/
    253.? ????????if(null?!=?$args)foreach($args?as?$key?=>?$arg)?$url?.=?"/{$key}/{$arg}";
    254.? ????}else{
    255.? ????????$url?=?$GLOBALS['G_SP']['url']["url_path_base"]."?".?$GLOBALS['G_SP']["url_controller"].?"={$controller}&";
    256.? ????????$url?.=?$GLOBALS['G_SP']["url_action"].?"={$action}";
    257.? ????????if(null?!=?$args)foreach($args?as?$key?=>?$arg)?$url?.=?"&{$key}={$arg}";
    258.? ????}
    259.? ????if(null?!=?$anchor)?$url?.=?"#".$anchor;
    260.? ????return?$url;
    261.? }
    262.?
    263.?
    23.? ????????eval($GLOBALS['G_SP']["dispatcher_error"]);
    24.? ????????exit;
    25.? ????}
    26.? ????//?路由并执行用户代码
    27.? ????$handle_controller->$__action();
    28.? ????//?控制器程序运行完毕,进行模板的自动输出
    29.? ????if(FALSE?!=?$GLOBALS['G_SP']['view']['auto_display']){
    30.? ????????$__tplname?=?$__controller.$GLOBALS['G_SP']['view']['auto_display_sep'].
    31.? ????????????????$__action.$GLOBALS['G_SP']['view']['auto_display_suffix'];?//?拼装模板路径
    32.? ????????$handle_controller->v->auto_display($__tplname);
    33.? ????}
    14.? ??????????),
    15.? ??????),
    16.? );
    17.? require(FN_PATH."/fn_common.php");
    18.? require(SP_PATH."/SpeedPHP.php");
    19.? spRun();