I have a real estate table divided into several categories and I want to list them on my PHP page. The detail is that I wish that in one region of the page are listed the houses, in another the apartments and so on. In other situations I did a select for each category, but I think this is not good in performance. So what would be the best way to do it?