Hi,

i have two tables category and hotels where category.id should be equal to hotels.catid. Now how do i select 3 rows from each different category from the hotels table.

I have this query:

select h.* from hotels h inner join category c on h.catid = c.id
order by h.catid, h.hid

this selects all records, but i want to select three rows per different category so in all it should return 9 rows with 3 rows for each category.

If this can not be done in mysql, you could also suggest php code please.

Thanks