dividing search query result into subcategories

[BlackRaven]

hi, ok having a bit of a problem with modifying my search to include subcategories display. Curretly my DB has the following fields

Title¦Price¦School

the thing is that i want the search results to show results accouring to the school field. Example

Physics for Engineers- Senneca College (8)

Physics for Engineers- Toronto University (2)

Physics for Engineers-Alberta college (1)

and so on....

i though of creating seperate tables for each school, but that would be a ton of tables for each school...to create modify and maintain.

Thank You

[jatar_k]

maybe take a look at GROUP BY [dev.mysql.com] in your SELECT [dev.mysql.com] statement