Thanks for your help! It

LRevillHendley — Wed, 29 Jun 2011 10:30:09 +0000

Thanks for your help! It nearly works, it doesn't understand the first b.businesses column, this is a little out of my league so if you could help that would be highly appreciated!

Thank you!

lrevillhendley.

Just woke up so mind is still

Greg K — Wed, 15 Jun 2011 17:14:27 +0000

Just woke up so mind is still waking up, but give this a try:

SELECT *, (SELECT COUNT(review_id) FROM reviews AS r WHERE r.business_id = b.businesses.id) AS review_count
FROM businesses AS b
JOIN loc_link AS ll ON ll.business_id = b.businesses.id 
JOIN cat_link AS cl ON cl.business_id = b.businesses.id 
WHERE ll.loc_id = '$loc_id' AND cat_link.cat_id = '$cat_id' AND businesses.active = 'true'
ORDER BY review_count

I don't really understand

LRevillHendley — Wed, 15 Jun 2011 13:20:01 +0000

I don't really understand what you are asking? I need to check how many reviews each business has within that SQL query and then order them by the amount of reviews they have so,

if business 1 has 3 reviews and business 2 has 1, then business 1 should be displayed 1st.

I know this can be done easily with mysql_num_rows() but I need to do it on the fly within the SQL query if possible, unless someone can come up with another idea as to how it can be done.

Cheers,

Leon.

did the table show the

sara — Wed, 15 Jun 2011 11:08:40 +0000

did the table show the reviews of the business and order by amount? because, if the question want to check the reviews, it can be to see on the table..and the answer is on the table..