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?

[litebearer]

see GROUP BY  http://www.tizag.com/mysqlTutorial/mysqlgroupby.php

[aspacecodyssey]

Thanks. It appears that would help me count items in a particular subcategory or to display the first of each -- but how would I set it to show the title of each subcategory, followed by all the items in that subcategory?

[PFMaBiSmAd]

You need to use an ORDER BY to get the rows in the order that you want. Then in your presentation logic, you remember the last subcategory and output a new heading when it changes. See this post for some sample code - http://www.phpfreaks.com/forums/index.php/topic,296615.msg1405059.html#msg1405059