shawntbanks
Programmer
I have this code, and when I select an Item from a menu, I want it to take me to a new page related to that iteml. Any help would be appricated.
<cfquery datasource="market" name="getvehicles">
select subcategory as vehicletype
, count(*) as vehicles
from adds
where subcategoryid in
( 1 -- cars
, 2 -- trucks & Vans
, 3 -- Boats & Watercraft
, 4 -- Motorcycles
, 5 -- RV's
, 6 -- SUV's
, 7 -- Snowmobiles
, 8 -- Auto Accessories
, 9 -- Farm Equipment
, 10 -- Heavy Equipment
, 11 -- Other
)
group by subcategory
order by subcategory
</cfquery>
<cfset totalvehicles
= ArraySum(ListToArray(
ValueList(getvehicles.vehicles)))>
<cfquery datasource="market" name="getrealestate">
select subcategory as realestatetype
, count(*) as realestate
from adds
where subcategoryid in
( 12 -- Residential - New
, 13 -- Residential - Resale
, 14 -- Vacation Property
, 15 -- Land
, 16 -- Commercial
, 17 -- Industrial
, 18 -- Investment Property
)
group by subcategory
order by subcategory
</cfquery>
<cfset totalrealestate
= ArraySum(ListToArray(
ValueList(getrealestate.realestate)))>
<body>
<form>
<table>
<tr><td><p><strong>Vehicles:
(<cfoutput>#totalvehicles#</cfoutput>
listings)</strong></p></td></tr>
<tr><td><select name="Vehicles" size="1">
<option>--- Choose One ---</option>
<cfoutput query="getvehicles">
<option>#getvehicles.vehicletype#
(#getvehicles.vehicles# listings)</option> </cfoutput></select></td></tr>
<tr><td><p><strong>Realestate:
(<cfoutput>#totalRealestate#</cfoutput>
listings)</strong></p></td></tr>
<tr><td><select name="realestate" size="1">
<option>--- Choose One ---</option>
<cfoutput query="getrealestate">
<option>#getrealestate.realestatetype#
(#getrealestate.realestate# listings)</option>
</cfoutput> </select></td></tr>
</table>
</form>
<cfquery datasource="market" name="getvehicles">
select subcategory as vehicletype
, count(*) as vehicles
from adds
where subcategoryid in
( 1 -- cars
, 2 -- trucks & Vans
, 3 -- Boats & Watercraft
, 4 -- Motorcycles
, 5 -- RV's
, 6 -- SUV's
, 7 -- Snowmobiles
, 8 -- Auto Accessories
, 9 -- Farm Equipment
, 10 -- Heavy Equipment
, 11 -- Other
)
group by subcategory
order by subcategory
</cfquery>
<cfset totalvehicles
= ArraySum(ListToArray(
ValueList(getvehicles.vehicles)))>
<cfquery datasource="market" name="getrealestate">
select subcategory as realestatetype
, count(*) as realestate
from adds
where subcategoryid in
( 12 -- Residential - New
, 13 -- Residential - Resale
, 14 -- Vacation Property
, 15 -- Land
, 16 -- Commercial
, 17 -- Industrial
, 18 -- Investment Property
)
group by subcategory
order by subcategory
</cfquery>
<cfset totalrealestate
= ArraySum(ListToArray(
ValueList(getrealestate.realestate)))>
<body>
<form>
<table>
<tr><td><p><strong>Vehicles:
(<cfoutput>#totalvehicles#</cfoutput>
listings)</strong></p></td></tr>
<tr><td><select name="Vehicles" size="1">
<option>--- Choose One ---</option>
<cfoutput query="getvehicles">
<option>#getvehicles.vehicletype#
(#getvehicles.vehicles# listings)</option> </cfoutput></select></td></tr>
<tr><td><p><strong>Realestate:
(<cfoutput>#totalRealestate#</cfoutput>
listings)</strong></p></td></tr>
<tr><td><select name="realestate" size="1">
<option>--- Choose One ---</option>
<cfoutput query="getrealestate">
<option>#getrealestate.realestatetype#
(#getrealestate.realestate# listings)</option>
</cfoutput> </select></td></tr>
</table>
</form>