i have pictures stored in a database(with fields such as the url, the title)
on the page, it displays a certain bunch of the pictures.

im gonna add another field that would have a string, and then when it read the database it'd sort by the string.

right now it just displays the pictures.

i want it to take all of the ones that having matching of the new field, then display them as a group.
and write
Groupname:
pic pic pic
Groupname2:
pic pic pic

did that make any sence?
I can rephraze it if it didnt. or even just link my site n stuff

Normalising the tables and using a JOIN that linked images to categories would make more sense from a data storage point of view.

But anyhoo
use a RS with a "ORDER BY category" clause

loop around the recordset as normal
keep a flag with the current category, when it changes write out the category name then go on with the loop.

is there a way to use order by twice? becuase I already have them sorted into other groups that are ordered. I kinda want them sorted into these new groups, then within those ordered by the first one. possible?

ORDER BY column1, column2, columnN

Thank you so much, that was very helpful. Here's where I used it.