I'm trying to get the output from my database to format into a specific pattern for a nested jquery accordion menu without having a million ugly queries and I'm hoping someone here can show me an easier way to accomplish it.
Ideally, the output would look like this:
... where Walt Disney World would be a manufacturer with associated product lines, and then associated products under that.
If anyone can help me with this, I'd be seriously appreciative. I suck at joins in the worst way and I'm just having trouble wrapping my head around an efficient way to write the queries(s).
// mysql structure
sort // order to be displayed among other manufacturers (INT)
series_man // associated man_id (INT)
sort // order to be displayed among other series (INT)
prod_series // associated series_id (INT)
sort // order to be displayed among other products (INT)
// end result for each manufacturer and related series, products. This block would replicate for each manufacturer
Thanks in advance for any help!