Drop Down Menus

[fnbcprog]

How do I tell one drop down box to do something base upon a previous selection box.

Kinda like select car maker: Toyota
Then select: Supra, camry

But the second box does not appear until the first is selected

[blindlizard]

I would post the information from the drop down to the server, then have the server re-render the page with the second drop down.

[eoghain]

Using just PHP, blindlizard is right, you will have to submit the selection from the first drop down and then build a new page based on that info.

If you want it to be dynamic you'll have to look into javascript or some other clientside programming. I don't know how to do it, just what is needed.

[ultraslacker]

I'd recommend doing it with java script + PHP - here's an example.

<script language="JavaScript">
function getYearsByCategory(category){
var url="issue_keylegislation.php?type=get_years&search_1="+category
window.location=url
}
</script>

// get the years for category
if ($type == "get_years" || $type == "category")
{
	$query = "SELECT DISTINCT year FROM carmodel WHERE category = '" . urldecode($search_1) . "' ORDER BY year desc";
	$result = $db->query($query);
	$select_box = new SelectBox("search_2");

// add items to year select box
while ($result_array = $result->fetchrow(DB_FETCHMODE_ASSOC))
{
	$select_box->add_item($result_array['year'], $result_array['year']);
}

$tpl->assign(SELECT_YEAR, $select_box->get_html());

// show years select box and GO button
$tpl->parse(ON_CHANGE, "issue_on_change");
}