Retrivimg value from the list box/text box

bettyatolive

Actually i have two text boxes region and type. I have to select a value from region( Whose values r in database) and based on tht value the type has to change.
For eg: If there are 2 regions North n South . And each region has it's own types. These values are stored in the database.
When I select region as north in the first listbox I should have the values "123" and "456".
When i select region as South in the first list box then it should be giving me drop down as "xyz","pqr".
These "123,"456","xyz","pqr" are stored in the database with their own region id's.

Wht i want is to autofil a field with values from a database based on what the user selects in the previous box? i.e North or South??

Houdini

Could you show the code that you presently have enclosed within [ php ] and [ /php } (without the spaces)?

bettyatolive

Houdini,
I din't give you any code. Any how i will show you what i have.

<td colspan="2" align=right><b>Select Region :</b></td>
 <td align=left><select name=rc style="width:100px">
        <option value=0>Select region</option>
<?
$res=$objDB->query("select * from Tbl_HO_ResourceCenter");
while($data=$objDB->fetchdata($res))
?>


<div align="right"><b>Account Head type:</b></td>
<td align=left><select name="accounthead" style="width:100p">
        <option value=0>--Select---</option>
<? $AHT=$objDB->query("select * from Tbl_HO_AccountHeadType where AT_RCID_FK= $rc "); 
 while($AHTRES=$objDB->fetchdata($AHT)){
?>

kburger

This actually sounds more like a JavaScript question than a PHP question. You could only use PHP to populate the second dropdown if you had the form submit once the first dropdown selection was made (using the JavaScript 'onChange' event). Not a very elegant solution.

A better solution is to use PHP on the server side to construct some JavaScript arrays for use on the client side. There are lots of tutorials out there. Here's one I just Googled up. http://www.mattkruse.com/javascript/dynamicoptionlist/ The tricky part is in dynamically constructing the JavaScript that will be used. I'd suggest 'hard coding' the JavaScript into the page until you get it working properly, then go back and use PHP to write that code dynamically.