Welcome Guest, Not a member yet? Register   Sign In
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



Theme © iAndrew 2016 - Forum software by © MyBB