Compare "" in

$limit) AND ($begin<$num_rows)) { $end=($start+$limit); } else { $end=$num_rows; } $pages=(floor($num_rows/$limit+1)); $thispage=(ceil($end/$limit)); $next = ($start+$limit); $prev = ($begin-$limit-1); ?>
Order By
Narrow Results
Display
Page of

of shoes

prev'; } else { echo 'prev'; } ?> next'; } else { echo 'next'; } ?>


There are no $page_brand shoes in this category. Check spelling or try to broadening your search criteria.

"; } $sql="SELECT *,count(rev_rate) AS num_rev,(sum(rev_rate)/count(rev_rate)) AS prod_rate,(SalePriceList/PriceList) AS sale FROM shoes,brands LEFT JOIN comparis_reviews on comparis_reviews.rev_prod_id = shoes.ProductID WHERE shoes.Brand = brands.brand_code AND brands.brand_id like '$brand_idq' AND (shoes.name like '%$shoeq%' OR shoes.Description like '%$shoeq%' OR shoes.StyleList like '%$shoeq%' OR shoes.SubStyleList like '%$shoeq%' OR shoes.KeywordList like '%$shoeq%' OR shoes.DepartmentList like '%$shoeq%' ) $sqlcat GROUP BY shoes.ProductID ORDER BY '$sort' $ord LIMIT $start, $limit"; $result=mysql_query($sql, $db) or die(mysql_error()); while ($newArray=mysql_fetch_array($result)) { $shoe_id=$newArray['ProductID']; $name=$newArray['Name']; $replace=array(" ","'","."); $name_url=strtolower(str_replace($replace,"-",$name)); $description=$newArray['Description']; $brand=$newArray['Brand']; $branddescription=ucwords(strtolower($newArray['BrandDescription'])); $price=$newArray['PriceList']; $saleprice=$newArray['SalePriceList']; $onsale=$newArray['OnSale']; $keyword=$newArray['KeywordList']; $url=$newArray['BuyURL']; $image=$newArray['SmallImageList']; $num_rev=$newArray['num_rev']; if($newArray['prod_rate']>0) { $prod_rate=number_format($newArray['prod_rate'],2); } else { $prod_rate=0; } $star_pos = (round(((5-$prod_rate)*2)+1))*15; if($saleprice<$price){ $off=round((1-($saleprice/$price))*100); $saletag=" $off% off at Shoes.com"; } echo '

'.$branddescription.' '.$name.'   MSRP '.$price.' '.$saletag.'

'.$keyword.'

'.$description.'

Buy Now

'.$prod_rate.'/5 for '.$branddescription.' '.$name.' ('.$prod_rate.'/5.00)   Rate this Shoe See Details and Read Reviews »
'; } ?> 0) { ?>
Prev'; } else { echo 'Prev'; } ?> of shoes
 Next'; } else { echo 'Next'; } ?>