Query Error

[liamoco]

This is the error is am getting

 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\server\xampp\htdocs\php\home\chats\home-chats.php on line 58

 

And this is the query

 

$popularToday_query = mysql_query("SELECT round(avg(likes)) + round(avg(favourites)) as rating, chat_name
                                   FROM chat_likes
		           GROUP BY chat_name 
	                   WHERE timeRated >= ".$curTime."
		           ORDER BY rating DESC 
	        	   LIMIT 4");

 

I have triple checked that I have all the field names correct, what am I doing wrong?

 

Thanks

[PFMaBiSmAd]

You can echo mysql_error(); to find out why the query is failing.

[liamoco]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE timeRated >= 1291833493 ORDER BY rating DESC ' at line 4

[Maq]

I believe GROUP BY should come right after your WHERE clause.

[liamoco]

Cheers Guys