Welcome Guest, Not a member yet? Register   Sign In
Outputting from two queries in my view?
#1

[eluser]ChrisF79[/eluser]
I want to output the cost of some products in a big table. For my example, let's say they're cars so it is easy to explain.

The make and models of the cars are stored in a table called Models. The specs of the cars (engine size, transmission, etc) are stored in Model_Specs. If someone says they want to see Ford, I have a query that goes out and selects all of the cars that are made by Ford and joins Model_Specs to bring all of that in.

A second query runs that goes out and finds the prices of each model from every dealership. So, there may be 3 versions of the Mustang and each version is sold at 10 different dealerships with 10 different prices.

How do I output that in my view? The first query would spit out a header with "Mustang 5.0 Convertible" and a little box with the specs for example The second query fetches the prices from the pricing table. I just don't understand using MVC how I'd build this sort of thing. Any advice owuld be greatly appreciated!


Messages In This Thread
Outputting from two queries in my view? - by El Forum - 11-13-2012, 01:15 PM
Outputting from two queries in my view? - by El Forum - 11-13-2012, 04:00 PM
Outputting from two queries in my view? - by El Forum - 11-13-2012, 04:13 PM
Outputting from two queries in my view? - by El Forum - 11-13-2012, 04:18 PM
Outputting from two queries in my view? - by El Forum - 11-13-2012, 04:25 PM
Outputting from two queries in my view? - by El Forum - 11-13-2012, 04:25 PM
Outputting from two queries in my view? - by El Forum - 11-13-2012, 04:29 PM



Theme © iAndrew 2016 - Forum software by © MyBB