Displaying SQL Data in groups

[aspacecodyssey]

I'm making a website for a restaurant and putting their menu into a MySQL database. Here's my table setup:

 

id    title    details    price    category    subcategory    region    beertype

 

So here's some example data:

 

6      Lunch Item 1        This is a test of Lunch Item #1.      14.75      lunch          Salads         

7      Dinner Iten 1        This is a test of Dinner Item 1.        16.00      dinner          Quesadillas       

8      Brunch Item 1      This is a test of Brunch Item 1.        6.87      brunch          Eggs       

13    Beerb 1                                                                4.75      beerb          CO    hardcider

 

 

Each "category" is given its own page. What I want to do is pull and display the data (PHP) so that it's grouped by "subcategory", like so:

 

Salads

--------

Salad 1 -- Price

Salad 2 -- Price

..etc.

 

Appetizers

-------

Appetizer 1 -- Price

Appetizer 2 -- Price

..etc.

 

Any way to do that? Array, perhaps?