Greetings,
I have a feedback rating system with the following code:
$sql = mysql_fetch_array(mysql_query("SELECT COUNT(*) as num FROM feedback WHERE receiver = '$seller' AND rating > 0"));
$totalcount = $sql['num'];
$sql = mysql_fetch_array(mysql_query("SELECT COUNT(*) as num FROM feedback WHERE receiver = '$seller' AND rating = '1'"));
$positivecount = $sql['num'];
$sql = mysql_fetch_array(mysql_query("SELECT COUNT(*) as num FROM feedback WHERE receiver = '$seller' AND rating = '2'"));
$negativecount = $sql['num'];
Basically I need all three values to come up with a percentage. I was wondering if there is a simple way to condense this into 1 query to save MySQL resources. I am trying to learn about ways to become more efficient and use less queries.
Thanks