if(!isset($limit)) {$limit="12";} if(!isset($start)) {$start="0";} if(!isset($sort)) {$ord="DESC";} if(!isset($sort)) {$sort="rev_date";} if(!isset($cat) OR ($cat=="")) {$sqlcat="";} else {$sqlcat="AND GenderList = '$cat'";} $begin=$start+1; require('db.inc'); $sql="SELECT *,count(rev_rate) AS num_rev,(sum(rev_rate)/count(rev_rate)) AS prod_rate FROM comparis_stores LEFT JOIN comparis_reviews ON comparis_reviews.rev_prod_id = comparis_stores.store_code WHERE store_code = '$shoe_id' GROUP BY comparis_stores.store_code"; $result=mysql_query($sql, $db) or die(mysql_error()); $newArray=mysql_fetch_array($result); $store_name=$newArray['store_name']; $store_code=$newArray['store_code']; $store_image=$newArray['store_image']; $store_url=$newArray['store_url']; $prod_rate=$newArray['prod_rate']; $store_description=$newArray['store_description']; $num_rev=$newArray['num_rev']; $star_pos = (round(((5-$prod_rate)*2)+1))*15; $page_title="$store_name Reviews - Consumer Ratings, Shoe Reviews and Price Comparison for $store_name"; $page_metad="Read consumer reviews for $store_name. Compare prices, service and selection for the most popular online shoe retailers at Comparison Shop Shoes."; require('header.inc'); ?>
Thank you for rating =$store_name ?>!
} ?>
=$store_description ?>
5/5 stars for =$store_name ?> =$prod_rate ?>/5 Stars - =$num_rev ?> Reviews
![]() |
Be the first to leave a review for $store_name
"; ?>Order By |
Display |
Page =$thispage ?> of =$pages ?> |
|---|---|---|
of shoes |
'.$rev_comments.'
| Prev'; } else { echo 'Prev'; } ?> | of reviews |
Next'; } else { echo 'Next'; } ?> |