站内搜索排序问题

交友网站搜索会员怎样使没形象照的会员排在有形象照会员后面.搜索结果页代码如下:
block_headinc.tpl"}-->
<body>

block_menu.tpl"}-->
<div id="page-index" class="page">
  <div class="search_max w960 online_page">
block_search.tpl"}-->
    <div class="search_sort">
      <div class="search_tips"> 共<span></span>人符合您的搜索条件 </div>
      <div class="search_sort_sle" id="rank">
    <strong>显示方式：</strong>
    <a class="btnc btn_c3" href="?c=user&a=list&page=&"> <span class='h'><b>头像模式</b></span> </a> 
<a class="btnc3 btn_c3" href="?c=user&a=list&page=&type=more&"> <span><b>独白模式</b></span> </a>
  </div>
    </div>
    <div class="online_list">      <ul class="search_pic_list clearfix">
    
        <li>

          <div class="search_user_bg"> <a target="_blank" href=""></a> </div>
          <div class="search_user_inform">
            <p class="search_user_t1"><a target="_blank" href=""></a> </p>
            <p class="search_user_add">岁  </p>
            <p class="search_vt">
<a class="btn_bt1 chat sayHiBtn" href="javascript:void(0);" onclick="jbox_hibox();"><span><img src="themes/images/d.gif"></span></a>
<a class="btn_bt2 mail sendEmailBtn" href="javascript:void(0);" onclick="jbox_writebox();"><span><img src="themes/images/r.gif"></span></a>
</p>
          </div>
        </li>
  
        <div style="clear:both;"></div>
      </ul>
      <div style="clear:both;"></div>   
      <div class="page1">
        <div class="pagecode">

        </div>
        <div style="clear:both;"></div>
      </div>

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

排序是在 sql 指令中进行的，与展示无关
那在哪修改?我找不到sql指令
那在哪修改?我找不到sql指令,下面是搜索代码
<div class="search_top">
      <form method="post" action="index.php?c=user&a=list" id="search_normal">
        <div class="search_in">
          <label id="search_scroll_bar_gender">我要找:</label>
  <select name='s_sex' id='s_sex'>
  <option value='2' selected>女会员</option>
  <option value='1' selected>男会员</option>
  </select>
          <label id="search_scroll_bar_age">  年龄:</label>
          
          <span>~</span>
          
          <label id="search_scroll_bar_workCity">  地区:</label>
           
  <span id="json_s_dist2">
    



  </span>            <input type="checkbox" value="1" name="s_avatar" id="s_avatar" checked />
          <label for="s_p_img">有形象照</label>
            <a class="ser" href="javascript:void(0);"><button type="submit">搜索</button></a>
你这显示的是视图，你可以通过sql来控制是否有图片的字段，具体看你怎么定义，
找到sql  order by 下即可。
在哪添加order by 语句.下面是搜索代码
<form method="post" action="<?php echo $_smarty_tpl->getVariable('urlpath')->value;?>
index.php?c=user&a=list" id="search_normal">
        <div class="search_in">
          <label id="search_scroll_bar_gender">我要找:</label>
  <select name='s_sex' id='s_sex'>
  <option value='2'<?php if ($_smarty_tpl->getVariable('s_sex')->value==2){?> selected<?php }?>>女会员</option>
  <option value='1'<?php if ($_smarty_tpl->getVariable('s_sex')->value==1){?> selected<?php }?>>男会员</option>
  </select>
          <label id="search_scroll_bar_age">  年龄:</label>
          <?php echo cmd_hook(array('mod'=>'age','name'=>'s_sage','text'=>'不限','value'=>'20'),$_smarty_tpl);?>          <span>~</span>
          <?php echo cmd_hook(array('mod'=>'age','name'=>'s_eage','text'=>'不限','value'=>'27'),$_smarty_tpl);?>          <label id="search_scroll_bar_workCity">  地区:</label>
          <?php echo cmd_area(array('type'=>'dist1','name'=>'s_dist1','value'=>$_smarty_tpl->getVariable('s_dist1')->value,'ajax'=>'1','cname'=>'s_dist2','cajax'=>'1','dname'=>'s_dist3','text'=>'=请选择='),$_smarty_tpl);?>
 
  <span id="json_s_dist2">
    <?php if ($_smarty_tpl->getVariable('s_dist1')->value>0){?>
<?php echo cmd_area(array('type'=>'dist2','pvalue'=>$_smarty_tpl->getVariable('s_dist1')->value,'cname'=>'s_dist2','cvalue'=>$_smarty_tpl->getVariable('s_dist2')->value,'cajax'=>'1','dname'=>'s_dist3','dvalue'=>$_smarty_tpl->getVariable('s_dist3')->value,'text'=>'=不限='),$_smarty_tpl);?> <?php }?>

  </span>            <input type="checkbox" value="1" name="s_avatar" id="s_avatar"<?php if ($_smarty_tpl->getVariable('s_avatar')->value==1){?> checked<?php }?> />
          <label for="s_p_img">有形象照</label>
            <a class="ser" href="javascript:void(0);"><button type="submit">搜索</button></a>
order by 用户头像图片储存字段  desc
下面是搜索代码,在哪添加order by 语句.
<?php
/*********************/
/*                   */
/*  Version : 5.1.0  */
/*  Author  : RM     */
/*  Comment : 071223 */
/*                   */
/*********************/if ( !defined( "IN_OESOFT" ) )
{
exit( "Access Denied" );
}
class userIService extends X
{ public function validSearch( )
{
$args = array( );
$countwhere = "";
$s_searchtype = XRequest::getargs( "s_searchtype" );
$s_sex = XRequest::getint( "s_sex" );
$s_sage = XRequest::getint( "s_sage" );
$s_eage = XRequest::getint( "s_eage" );
$s_dist1 = XRequest::getint( "s_dist1" );
$s_dist2 = XRequest::getint( "s_dist2" );
$s_dist3 = XRequest::getint( "s_dist3" );
$s_lovesort = XRequest::getint( "s_lovesort" );
$s_sheight = XRequest::getint( "s_sheight" );
$s_eheight = XRequest::getint( "s_eheight" );
$s_ssalary = XRequest::getint( "s_ssalary" );
$s_esalary = XRequest::getint( "s_esalary" );
$s_sedu = XRequest::getint( "s_sedu" );
$s_eedu = XRequest::getint( "s_eedu" );
if ( $s_searchtype == "adv" )
{
$s_marry = XRequest::getcomints( "s_marry" );
$s_havechild = XRequest::getcomints( "s_havechild" );
}
else
{
$s_marry = XRequest::getargs( "s_marry" );
$s_havechild = XRequest::getargs( "s_havechild" );
}
$s_house = XRequest::getint( "s_house" );
$s_car = XRequest::getint( "s_car" );
$s_avatar = XRequest::getint( "s_avatar" );
$args = array(
"s_sex" => $s_sex,
"s_sage" => $s_sage,
"s_eage" => $s_eage,
"s_dist1" => $s_dist1,
"s_dist2" => $s_dist2,
"s_dist3" => $s_dist3,
"s_lovesort" => $s_lovesort,
"s_sheight" => $s_sheight,
"s_eheight" => $s_eheight,
"s_ssalary" => $s_ssalary,
"s_esalary" => $s_esalary,
"s_sedu" => $s_sedu,
"s_eedu" => $s_eedu,
"s_marry" => $s_marry,
"s_havechild" => $s_havechild,
"s_house" => $s_house,
"s_car" => $s_car,
"s_avatar" => $s_avatar
);
$sql = "";
if ( 0 < $s_sex )
{
$sql .= " AND v.gender='".$s_sex."'";
$countwhere .= " AND ps.gender='".$s_sex."'";
}
if ( 0 < $s_sage && 0 < $s_eage )
{
$year = date( "Y", time( ) );
$sageline = $year - $s_eage;
$eageline = $year - $s_sage;
$sql .= " AND p.ageyear >= ".$sageline." AND p.ageyear <= {$eageline}";
$countwhere .= " AND ps.ageyear >= ".$sageline." AND ps.ageyear <= {$eageline}";
}
if ( 0 < $s_dist1 )
{
$sql .= " AND p.provinceid='".$s_dist1."'";
$countwhere .= " AND ps.provinceid='".$s_dist1."'";
}
if ( 0 < $s_dist2 )
{
$sql .= " AND p.cityid='".$s_dist2."'";
$countwhere .= " AND ps.cityid='".$s_dist2."'";
}
if ( 0 < $s_dist3 )
{
$sql .= " AND p.distid='".$s_dist3."'";
$countwhere .= " AND ps.distid='".$s_dist3."'";
}
if ( 0 < $s_lovesort )
{
$sql .= " AND p.lovesort='".$s_lovesort."'";
$countwhere .= " AND ps.lovesort='".$s_lovesort."'";
}
if ( 0 < $s_sheight && 0 < $s_eheight )
{
$sql .= " AND p.height >= ".$s_sheight." AND p.height <= {$s_eheight}";
$countwhere .= " AND ps.height >= ".$s_sheight." AND ps.height <= {$s_eheight}";
}
if ( 0 < $s_ssalary && 0 < $s_esalary )
{
$sql .= " AND p.salary >= ".$s_ssalary." AND p.salary <= {$s_esalary}";
$countwhere .= " AND ps.salary >= ".$s_ssalary." AND ps.salary <= {$s_esalary}";
}
if ( 0 < $s_sedu && 0 < $s_eedu )
{
$sql .= " AND p.education >= ".$s_sedu." AND p.education <= {$s_eedu}";
$countwhere .= " AND ps.education >= ".$s_sedu." AND ps.education <= {$s_eedu}";
}
if ( TRUE === XValid::iscomchar( $s_marry ) )
{
$sql .= " AND p.marrystatus IN (".$s_marry.")";
$countwhere .= " AND ps.marry IN (".$s_marry.")";
}
if ( TRUE === XValid::iscomchar( $s_havechild ) )
{
$sql .= " AND p.childrenstatus IN (".$s_havechild.")";
$countwhere .= " AND ps.child IN (".$s_havechild.")";
}
if ( 0 < $s_house )
{
$sql .= " AND p.housing='".$s_house."'";
$countwhere .= " AND ps.house='".$s_house."'";
}
if ( 0 < $s_car )
{
$sql .= " AND p.caring='".$s_car."'";
$countwhere .= " AND ps.car='".$s_car."'";
}
if ( $s_avatar == 1 )
{
$sql .= " AND v.avatar != '' AND v.avatarflag = '1'";
$countwhere .= " AND ps.avatar='1'";
}
return array(
$sql,
$countwhere,
$args
);
} public function validUid( )
{
$uid = XRequest::getint( "s_uid" );
if ( FALSE === XValid::isnumber( $uid ) || $uid < 0 )
{
$uid = 0;
}
return $uid;
} public function validUserName( )
{
$username = XRequest::getargs( "s_username" );
if ( FALSE === XValid::isuserargs( $username ) )
{
$username = "";
}
return $username;
} public function validType( )
{
$type = XRequest::getargs( "type" );
return $type;
}}?>
上面那个乱,我重新整理了下,在最后面我加上了order by  avatarflag desc.搜索时报错:Parse error: syntax error, unexpected T_STRING, expecting ')' in E:\PHPnow-1.5.6\htdocs\source\service\index\service.user.php on line 147
报错行就是最后一行:order by  avatarflag desc.搜索代码如下:
public function validSearch( )
{
$args = array( );
$countwhere = "";
$s_searchtype = XRequest::getargs( "s_searchtype" );
$s_sex = XRequest::getint( "s_sex" );
$s_sage = XRequest::getint( "s_sage" );
$s_eage = XRequest::getint( "s_eage" );
$s_dist1 = XRequest::getint( "s_dist1" );
$s_dist2 = XRequest::getint( "s_dist2" );
$s_dist3 = XRequest::getint( "s_dist3" );
$s_lovesort = XRequest::getint( "s_lovesort" );
$s_sheight = XRequest::getint( "s_sheight" );
$s_eheight = XRequest::getint( "s_eheight" );
$s_ssalary = XRequest::getint( "s_ssalary" );
$s_esalary = XRequest::getint( "s_esalary" );
$s_sedu = XRequest::getint( "s_sedu" );
$s_eedu = XRequest::getint( "s_eedu" );
if ( $s_searchtype == "adv" )
{
$s_marry = XRequest::getcomints( "s_marry" );
$s_havechild = XRequest::getcomints( "s_havechild" );
}
else
{
$s_marry = XRequest::getargs( "s_marry" );
$s_havechild = XRequest::getargs( "s_havechild" );
}
$s_house = XRequest::getint( "s_house" );
$s_car = XRequest::getint( "s_car" );
$s_avatar = XRequest::getint( "s_avatar" );
$args = array(
"s_sex" => $s_sex,
"s_sage" => $s_sage,
"s_eage" => $s_eage,
"s_dist1" => $s_dist1,
"s_dist2" => $s_dist2,
"s_dist3" => $s_dist3,
"s_lovesort" => $s_lovesort,
"s_sheight" => $s_sheight,
"s_eheight" => $s_eheight,
"s_ssalary" => $s_ssalary,
"s_esalary" => $s_esalary,
"s_sedu" => $s_sedu,
"s_eedu" => $s_eedu,
"s_marry" => $s_marry,
"s_havechild" => $s_havechild,
"s_house" => $s_house,
"s_car" => $s_car,
"s_avatar" => $s_avatar
);
$sql = "";
if ( 0 < $s_sex )
{
$sql .= " AND v.gender='".$s_sex."'";
$countwhere .= " AND ps.gender='".$s_sex."'";
}
if ( 0 < $s_sage && 0 < $s_eage )
{
$year = date( "Y", time( ) );
$sageline = $year - $s_eage;
$eageline = $year - $s_sage;
$sql .= " AND p.ageyear >= ".$sageline." AND p.ageyear <= {$eageline}";
$countwhere .= " AND ps.ageyear >= ".$sageline." AND ps.ageyear <= {$eageline}";
}
if ( 0 < $s_dist1 )
{
$sql .= " AND p.provinceid='".$s_dist1."'";
$countwhere .= " AND ps.provinceid='".$s_dist1."'";
}
if ( 0 < $s_dist2 )
{
$sql .= " AND p.cityid='".$s_dist2."'";
$countwhere .= " AND ps.cityid='".$s_dist2."'";
}
if ( 0 < $s_dist3 )
{
$sql .= " AND p.distid='".$s_dist3."'";
$countwhere .= " AND ps.distid='".$s_dist3."'";
}
if ( 0 < $s_lovesort )
{
$sql .= " AND p.lovesort='".$s_lovesort."'";
$countwhere .= " AND ps.lovesort='".$s_lovesort."'";
}
if ( 0 < $s_sheight && 0 < $s_eheight )
{
$sql .= " AND p.height >= ".$s_sheight." AND p.height <= {$s_eheight}";
$countwhere .= " AND ps.height >= ".$s_sheight." AND ps.height <= {$s_eheight}";
}
if ( 0 < $s_ssalary && 0 < $s_esalary )
{
$sql .= " AND p.salary >= ".$s_ssalary." AND p.salary <= {$s_esalary}";
$countwhere .= " AND ps.salary >= ".$s_ssalary." AND ps.salary <= {$s_esalary}";
}
if ( 0 < $s_sedu && 0 < $s_eedu )
{
$sql .= " AND p.education >= ".$s_sedu." AND p.education <= {$s_eedu}";
$countwhere .= " AND ps.education >= ".$s_sedu." AND ps.education <= {$s_eedu}";
}
if ( TRUE === XValid::iscomchar( $s_marry ) )
{
$sql .= " AND p.marrystatus IN (".$s_marry.")";
$countwhere .= " AND ps.marry IN (".$s_marry.")";
}
if ( TRUE === XValid::iscomchar( $s_havechild ) )
{
$sql .= " AND p.childrenstatus IN (".$s_havechild.")";
$countwhere .= " AND ps.child IN (".$s_havechild.")";
}
if ( 0 < $s_house )
{
$sql .= " AND p.housing='".$s_house."'";
$countwhere .= " AND ps.house='".$s_house."'";
}
if ( 0 < $s_car )
{
$sql .= " AND p.caring='".$s_car."'";
$countwhere .= " AND ps.car='".$s_car."'";
}
if ( $s_avatar == 1 )
{
$sql .= " AND v.avatar != '' AND v.avatarflag = '1'";
$countwhere .= " AND ps.avatar='1'";
}

return array(
$sql,
$countwhere,
$args
order by  avatarflag desc
);

}