Sephiroth_ronin

Ok I got the data from the query. The only problem I have is that I want to show the information in a table with SEASON_name as rows, ROOMTYPE_name as colums and in the cell joining the row and column : the PRICE (if there is one, if not = NULL !?!). It should look like this :                             SEASON_name1          SEASON_name2            ... ROOMTYPE_name1    PRICE                        PRICE ROOMTYPE_name2    PRICE2                        PRICE ...

Thank you for that ! Can you give me an example of a loop that I could use and that you know of ? Thanks again for you help !

Hello everyone, I need your help ! This is what I have as my 3 tables and their variables: TABLE NAME: room_type - ROOMTYPE_id - ROOMTYPE_hostel - ROOMTYPE_beds - ROOMTYPE_bathroom TABLE NAME: season - SEASON_id - SEASON_name - SEASON_start - SEASON_end TABLE NAME: prices - PRICE_id - SEASON_id - ROOMTYPE_id - PRICE Now I would like to have the results displayed in a PHP table like so:                             SEASON_name1    SEASON_name2 ... ROOMTYPE_beds1    PRICE                  PRICE ROOMTYPE_beds2    PRICE                  PRICE ... Can someone help me !?