1 reply to this topic

[Bertan]

I been trying to put these two queries into one, anyone know how this can be accomplished?

$query = "SELECT COUNT(rate) AS Likes 

		  FROM ratings				

		  WHERE image_id = '{$image_id}' AND rate = 1";

$result = mysql_query($query);

$rate1 = mysql_fetch_assoc($result);


$query = "SELECT COUNT(rate) AS Dislikes 

		  FROM ratings				

		  WHERE image_id = '{$image_id}' AND rate = -1";

$result = mysql_query($query);

$rate2 = mysql_fetch_assoc($result);


echo $rate1['Likes'], $rate2['Dislikes'];

Thanks for any help

Yours,
Bertan

[WingedPanther]

SELECT COUNT(rate) AS Likes , rate FROM ratings group by rate WHERE image_id = '{$image_id}'