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 * FROM shoes WHERE ProductID = '$shoe_id'";
$result=mysql_query($sql, $db) or die(mysql_error());
$newArray=mysql_fetch_array($result);
$brand_name1=ucwords(strtolower($newArray['BrandDescription']));
$name=$newArray['Name'];
$mainimage=str_replace("/SHOES_IC","/SHOES_IA",$newArray['MainImageList']);
$price=$newArray['PriceList'];
$saleprice=$newArray['SalePriceList'];
$onsale=$newArray['OnSale'];
$buyurl=$newArray['BuyURL'];
$shoedesc=$newArray['Description'];
$keywordlist=$newArray['KeywordList'];
$page_title="$brand_name1 $name: Read Reviews, Compare Prices and Find Online Retailers for $brand_name1 $name";
$page_metad="Consumer reviews and online shoe store price comparisons for $brand_name1 $name from Comparison Shop Shoes.";
require('header.inc');
?>
Read Reviews for Shoes
if(isset($_GET['rate'])) { ?>
Thank you for rating this shoe!
} ?>
Available From: |
|
$=$saleprice ?> |
| 5/5 stars for Shoes.com |
Buy Now |
- Free US Shipping
- International Shipping
- Free Returns
- 115% Low Price Guarantee
- Sales tax for CA, MO and TN Residents
Read Shoes.com Reviews » |
|
|
 |
| =$shoedesc ?> |
$sql="SELECT * FROM comparis_reviews WHERE rev_prod_id = '$shoe_id'";
$result=mysql_query($sql, $db) or die(mysql_error());
$num_rows=mysql_num_rows($result);
// BEGIN PAGINATE
if(($num_rows>$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);
if($num_rows=mysql_num_rows($result)==0) {
echo"
Be the first to leave a review for $brand_name1 $name
";
?>
}
?>
if($num_rows=mysql_num_rows($result)>0) {
?>
$sql="SELECT *, DATE_FORMAT(rev_date,'%W, %M %e, %Y') AS rev_date2 FROM comparis_reviews
LEFT JOIN comparis_users ON comparis_users.user_id = comparis_reviews.rev_user_id
WHERE rev_prod_id = '$shoe_id'
GROUP BY rev_id
ORDER BY '$sort' $ord LIMIT $start, $limit";
$result=mysql_query($sql, $db) or die(mysql_error());
while ($newArray=mysql_fetch_array($result)) {
$rev_user_id=$newArray['rev_user_id'];
$rev_date=$newArray['rev_date2'];
$rev_time=$newArray['rev_time'];
$rev_comments=$newArray['rev_comments'];
$num_rev=$newArray['num_rev'];
if($newArray['rev_rate']>0) { $prod_rate=$newArray['rev_rate']; } else { $prod_rate=0; }
$star_pos = (round(((5-$prod_rate)*2)+1))*15;
$user_name=$newArray['user_name'];
$user_id=$newArray['user_id'];
echo'
'.$prod_rate.'/5 stars for '.$branddescription.' '.$name.'
('.$prod_rate.'/5) '.$rev_date.'
'.$user_name.'
'.$rev_comments.'
';
}
?>
| Prev'; } else { echo 'Prev'; } ?> |
of reviews
|
Next'; } else { echo 'Next'; } ?> |
} ?>
require('footer.inc');
?>