Any ideas?

Hi people, Any ideas on how I can achieve the below scenario? I am using PHP3 and MYSQL 1 table containing product description, price and category. I can do a simple query to dump out all the data in tabluar form. ie description, price, category However, I need the data to be in the form of: Category description price description price category 2 description price description price etc etc. Is there a way that I can get the category field from the table and use it as a table header? then under this displaying the products that only fall into that category? A code example might be useful here as I am fairly new to both php and MYSQL Thanks in advance. Shannon