Query Help

Hi people, I have a small problem with a select cause that I need to use. I basically need the following. Select * from table where page =3D=3D page_name The fields in the db are code,description,unit,price,category,minor_category Then the display needs to be something along the lines of Category Name Minor Category Code Description Unit Price Minor Category Code Description Unit Price Category Name Minor Category Code Description Unit Price The number of minor categories differ for each of the categories, as to = do the number of products in each minor_category. I could hard code in the Category Names, however, they are meant to be = dynamic as they will be changing on a monthly basis. Any help would be appreciated. Thanks Shannon _______________________________ Shannon Doyle Web Design Consultant BIGBLUE Internet Pty Ltd 149 Hutt St, Adelaide SA 5000 Ph +61 8 8232 1444 Fax +61 8 8232 8577 http://www.bigblue.net.au