asked on
<?php
// THIS DOES NOT PRODUCE 82
function getReviews() {
mysql_select_db($database_EBW_Conn, $EBW_Conn);
$query_rsReviews = "SELECT count(r.review_id) as cnt, pp.itemname, pp.itemid, ra.percent_approved FROM product_price pp, reviews r, ratings_aggregated ra WHERE pp.entity_id = r.entity_id AND r.entity_id = ra.entity_id AND pp.itemsection = 'toys' AND pp.itemurl = 'rubber-duckie' AND r.status_id = 1 GROUP BY pp.itemname";
$rsReviews = mysql_query($query_rsReviews, $EBW_Conn);
$row_rsReviews = mysql_fetch_assoc($rsReviews);
$totalRows_rsReviews = mysql_num_rows($rsReviews);
if ($totalRows_rsReviews > 0) {
do {
echo "4 ";
echo ($row_rsReviews['cnt']); // 82
} while ($row_rsReviews = mysql_fetch_assoc($rsReviews));
}
mysql_free_result($rsReviews);
}
getReviews();
?>
<?php
// THIS DOES PRODUCE 82
//function getReviews() {
mysql_select_db($database_EBW_Conn, $EBW_Conn);
$query_rsReviews = "SELECT count(r.review_id) as cnt, pp.itemname, pp.itemid, ra.percent_approved FROM product_price pp, reviews r, ratings_aggregated ra WHERE pp.entity_id = r.entity_id AND r.entity_id = ra.entity_id AND pp.itemsection = 'toys' AND pp.itemurl = 'rubber-duckie' AND r.status_id = 1 GROUP BY pp.itemname";
$rsReviews = mysql_query($query_rsReviews, $EBW_Conn);
$row_rsReviews = mysql_fetch_assoc($rsReviews);
$totalRows_rsReviews = mysql_num_rows($rsReviews);
if ($totalRows_rsReviews > 0) {
do {
echo "4 ";
echo ($row_rsReviews['cnt']); // 82
} while ($row_rsReviews = mysql_fetch_assoc($rsReviews));
}
mysql_free_result($rsReviews);
//}
getReviews();
?>