$whereqry="";
$gwhereqry="";
if($category){
$whereqry .= " AND category='".$category."'";
$gwhereqry .= " AND largeno = '".$category."'";
}
if($_GET[searchkey]){
$startStr = $strArr[$_GET[searchkey]];
if($_GET[searchkey]=="41"){
$endStr = "99";
}
else{
$endStr = $strArr[$_GET[searchkey]+1];
}
if($_GET[searchkey] < 27){
$whereqry .= " AND ( ( name >= binary('".$startStr."') AND name < binary('".$endStr."') ) OR ( name >= binary('".strtolower($startStr)."') AND name < binary('".strtolower($endStr)."') ) )";
}else{
$whereqry .= " AND name >= binary('".$startStr."') AND name < binary('".$endStr."') ";
}
}
$total = $objdb->sqlNumRows("SELECT name FROM brand WHERE 1=1 ".$whereqry." GROUP BY name");
if($_GET[searchkey]) $addOrderBy = "binary(name), ";
$sql = "SELECT name, image, content, category FROM brand where 1=1".$whereqry." GROUP BY name ORDER BY ".$addOrderBy."category, sortno LIMIT ".$START.", ".$PageSize;
$brandCateArr = $objdb->sqlArray($sql);
$thisPageTotal = count($brandCateArr);
for($i=0;$i<$thisPageTotal;$i = $i+2){
?>
$sql = "SELECT code, name, price, saleprice, smallimg1 FROM good WHERE chkrec='y' AND chkuse='y' AND company='".$brandCateArr[$cnt][name]."' AND company <> '' ".$gwhereqry." ORDER BY wdate DESC LIMIT 2";
$result = $objdb->sqlResult($sql);
$cnt=0;
while($row=$objdb->sqlFetch($result)){
?>