Populate drop down box from database?

[jarrodr]

Sorry guys, but I am a total noob with Joomla.

I need populate 2 drop down boxes with data from my database and when the search button is hit a datagrid is populated and displayed on screen. The drop down boxes are basically filters.

eg.

The 1st drop down box filters the 2nd drop down box.
1st DDL (Car Manufactures), 2nd DDL (Car Models, depending on the manufacture chosen), Honda->CRV.

When the search button is hit, the table displays all CRV models. When any row from the table is chosen, a static details page about the car opens up.

Please guys can you assist.

[ooffick]

Hi,

This sounds like you want to develop your own component, have a look here, regarding the select boxes:
http://api.joomla.org/Joomla-Framework/ ... enericlist

And here, to learn how to develop your own component:
http://docs.joomla.org/Category:Development
http://docs.joomla.org/Developing_a_Mod ... t_-_Part_1
http://docs.joomla.org/Developing_a_Mod ... ng_a_Model
http://docs.joomla.org/Developing_a_Mod ... e_Database
http://docs.joomla.org/Developing_a_Mod ... _Interface
http://docs.joomla.org/Developing_a_Mod ... _Framework
http://docs.joomla.org/Developing_a_Mod ... nd_Actions


Mod Note: Bump post deleted, please do not bump your posts.

Olaf

[dam-man]

The 1st drop down box filters the 2nd drop down box.
1st DDL (Car Manufactures), 2nd DDL (Car Models, depending on the manufacture chosen), Honda->CRV.

I've done this also in my component, see http://rd-media.org for the use of my selectors.

[jarrodr]

Thanks guys, I'll test it when I get home... Will def. give feedback.