What is the best way to loop through a query result and then for each result run another query based on result information.
Example:
Query 1: Names
Jim
-> Query 2: Colors
-- Red
-- Blue
-- Black
Bob
-> Query 2: Colors
-- Green
-- Purple
-- Pink
Im not sure how to get information like this from the model to the controller to the view. Where do I set up the looping pattern? In models? Or the controller?
Maybe its just a more advanced sql join and its all done in one query?
Noob to fuel. Thnx.
Donate
