• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
joint query

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 xref
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.


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.

Hi ladamis,
You are looking for explanation how to create query with multiple joins and how to use returned result, right?

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.