tibberous Posted July 5, 2008 Share Posted July 5, 2008 I have two tables, products and ratings. Products have ratings, but the products table doesn't store the number of ratings. To find the number of ratings for a particular product, you just do a "select count(*) from ratings where Owner='productID'". How can I have this added on to all my products in a query? I was thinking something like... select *, (select count(*) from `ratings` where Owner=`products`.id) as numberOfRatings from `ratings`, `products` That gives an error though =/ Any ideas? Link to comment https://forums.phpfreaks.com/topic/113351-how-can-i-attach-the-count-of-a-row-to-a-query/ Share on other sites More sharing options...
tibberous Posted July 5, 2008 Author Share Posted July 5, 2008 I got it. You only select from the products table. Link to comment https://forums.phpfreaks.com/topic/113351-how-can-i-attach-the-count-of-a-row-to-a-query/#findComment-582351 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.