Does this look ok?

[dhimok]

Can anybody tell me if theres something wrong with this query

 

$result = dbQuery("
SELECT SUM(reviews_stars) AS REVIEWS FROM ".TABLE_PRODUCT_REVIEWS.", ".TABLE_PRODUCTS."
WHERE ".TABLE_PRODUCT_REVIEWS.".product_id = ".TABLE_PRODUCTS.".product_id
GROUP BY ".TABLE_PRODUCT_REVIEWS.".product_id
ORDER BY REVIEWS DESC
LIMIT $offset, $rowsPerPage
");

[darkfreaks]

<?php 
$result = mysql_query("
SELECT SUM 'reviews_stars' AS REVIEWS FROM ".TABLE_PRODUCT_REVIEWS.", ".TABLE_PRODUCTS."
WHERE ".TABLE_PRODUCT_REVIEWS.".product_id = ".TABLE_PRODUCTS.".product_id
GROUP BY ".TABLE_PRODUCT_REVIEWS.".product_id
ORDER BY REVIEWS DESC
LIMIT $offset, $rowsPerPage
");?>

[Jessica]

Why are you asking? Is there an error?

[dhimok]

I am getting the right number of results but empty ones with this errror

 

Notice: Undefined property: stdClass::$product_name

 

and heres the full code

 

<?php

$retval = '';

$result = dbQuery("
SELECT SUM(reviews_stars) AS REVIEWS FROM ".TABLE_PRODUCT_REVIEWS.", ".TABLE_PRODUCTS."
WHERE ".TABLE_PRODUCT_REVIEWS.".product_id = ".TABLE_PRODUCTS.".product_id
GROUP BY ".TABLE_PRODUCT_REVIEWS.".product_id
ORDER BY REVIEWS DESC
LIMIT $offset, $rowsPerPage
");


  	if(dbNumRows($result) > 0) {
$total = dbNumRows($result);

	while($row = dbFetchObject($result)) {

		$retval .= '<div>';
		$retval .= '<h3>'. $row->product_name .'</h3>';
		$retval .= '</div>';

	}
}

?>

[darkfreaks]

<?php $row=>[product_name]; ?>

[Barand]

You don't select product_name.

[dhimok]

Exactly. I thought by using fetchObject class wasnt necessary to select. But it works now as u said, thanks