How to Output Overall Review-count for a Place/Event Category?

Dear Vikas!

I made a custom widget for the front content section. I would like it to work as the widget on yelp’s homepage.

There’s a list with all the categories. I would like to output the overall review-count belongs to a category. So, not the review-count for one place, but the overall review-count for the given category.

I’m also interested about how to diplay the current location!?

Thanks!

Dear Paolo!

Thank you for your reply!

I’m not native english, so sorry for my grammar. Maybe I was misleading in my previous post.

What I mean is something like this: I have a “Restaurants” category, and there’s e.g. 20 restaurant listings in it. Every listing has e.g. 2 reviews. It means that I have 40 reviews in my “Restaurants” category. And I would like to output that “40”, if you know what I mean. Not the average, but the total count of ratings in one category.

I’m also interested about how to display the current location, anywhere on the page.

I uploaded the pic again, about my widget. Hope it will help you understand what I mean.

Thank You!

Dear Paolo!

I’m never done such things like before, but with a $wpdb class and a few line of code, I was able to resolve one of my problem.

If anyone interested, here’s the code:

<?php global $wpdb;

	$result = mysql_query(
	'
	  SELECT default_category, SUM(rating_count) AS value_sum 
	  FROM geodir_gd_place_detail
	  WHERE default_category = "2"
	  GROUP BY default_category;                                    
	'
	);

	$row = mysql_fetch_assoc($result);
	$sum = $row['value_sum'];
	echo $sum;
?>

In this example my “Restaurants” default category has the id=2. Right now it’s only works with default categories, but I’m still working on it. I will like to use gd_default_category instead of default_category column.

Keep up the good work, Guys!

Dear Vikas!

Thank you for your reply!

I will check it out when I got home, and let you know!

Best Regards