I am building a "Smart" image gallery for my clients and one of the things they want to do is display the pedigree relationships between their alpacas. You can see the Pedigree ER diagram here:-
They basically want to show that table structure on the website, but obviously formatted nicely in HTML. So my question is, what would be the best approach to get that data in the least queries? Im concerned this could be quite expensive in terms of how many queries are used if im not careful!
I really hope that made sense! Any questions please just ask
Kind regards and thanks,