3 Replies Latest reply on Dec 30, 2007 6:02 AM by glensbo

    More effective way to do this page with one recordset instead of four?

    Level 1
      I just created a homepage for a client that is supposed to display real estate properties from four different categories sorted by the most expensive rent. Only way it seemed I could do it was to create a Query using QuB and then from that creating four recordsets. One for each category: Single/Studio Apartments, One Bedroom Apartments, Two Bedroom Apartments and Three Bedroom Apartments. Resulting page is here:

      So yes, it does work and display nicely. But I'm wondering if there's a more effective way to do this using ADDT with just one recordset since I'm still kind of new to all this. The PHP code is posted here if you want to peek at what I did: