joint query |
[eluser]Unknown[/eluser]
hi everyone, I have been looking for a tutorial that describes how to deal with multiple tables. with larger sites there are multiple tables cross referenced. for example in a store we have to make a query for product image product - image xref category product - category xref and so on... so my question is, since I can only send one set of data from the Model to the View I seem to have to make one big query that pulls everything. in php I used to make loops in loops. like query for product and then inside that loop I would query for images related for that product. can anyone show me an example how I am supposed to deal with this in the MVC structure. the examples out there don't go farther than explaining the MVC structure with one table in the data base. thanks, luke
[eluser]zimco[/eluser]
If i correctly understood what you were asking about: performing multiple queries on different tables in one database. I think this thread Please Help Multiple Queries might help you.
[eluser]mironcho[/eluser]
Hi ladamis, You are looking for explanation how to create query with multiple joins and how to use returned result, right? |
Welcome Guest, Not a member yet? Register Sign In |