dropdown onchange to select mysql with php

[rcouser]

Hello There,
I am trying to create a dropdown that selects mysql with php. For example I have two select dropdowns the first with types and second with products. So when the types select is click the products from that category are listed in the product select.

<select name="type" id="type">
<option value="1">Accessories</option>						
<option value="2">Cables</option>						
 </select>
<select name="product_item"  id="product_item">
<option value=""></option>
</select></p>

Thanks,
Ryan

[bdl]

To clarify, are you asking how to retrieve data through an XMLHttpRequest call via PHP/MySQL and populate the contents, or how to change it around using the DOM once PHP has already built the structure?

[Old Pedant]

Or do you simply want to post back to PHP after the first <SELECT> is changed and then regenerate the entire page with the new second <SELECT>? That's probably the easiest way for a newbie to approach the problem.