Hi, I hope this is the right section
Say I have a pet shop, and I have the following table.
species breed
===== =====
Dog Poodle
Dog Labrador
Dog Pekinese
Dog Dalmatian
Cat Persian
Cat Tabby
and I want to display the table contents on a web page.
I'd like to have a big heading every time the species changes, something like
DOG
===
Poodle
Labrador
Pekinese
Dalmatian
CAT
===
Persian
Tabby
is there any way of doing this?
I know a way of doing it in MySQL but I also have an image for each animal, and I want to be able to do stuff like setWidth and so on. If I do a SQLQuery() I will lose that functionality.
I've also tried to merge two DataObjects but then I get the same records twice, once with the images, once without.
Any ideas?