Help Counting the comments from a table

[eluser]mddd[/eluser]
You need to GROUP BY the relevant id. That is the hotel id, or the hotel data id, depending on how your tables work exactly. Anyway, do the grouping on the thing that identifies the group of comments you want to count. Then use COUNT to count the comments per group.

A simplied version: if you had only a table of hotels and a table of comments:

Code:

SELECT hotels.*, COUNT(comments.id) AS num_comments
FROM hotels
JOIN comments on comments.hotel_id = hotels.id