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

#1
[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


Messages In This Thread
joint query - by El Forum - 05-19-2008, 09:59 AM
joint query - by El Forum - 05-19-2008, 11:28 AM
joint query - by El Forum - 05-19-2008, 11:58 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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