Drop down Event which calls php scripts

[cuvaibhav]

Hi,

I have a drop down whose values are as follows and will be stored in a sql table:
-one
-two
-three

When a value is selected in drop down then a certain list has to be displayed which needs to be pulled from sql table... list will vary based on selection...
e.g., When one is selected then display following items:
1] one
2] one one
3] one one one

I am new in php so please guide me how to make this happen or please provide a sample code....

Thanks and Regards,
Vaibhav

[Muddasir]

Hi,

I have a drop down whose values are as follows and will be stored in a sql table:
-one
-two
-three

When a value is selected in drop down then a certain list has to be displayed which needs to be pulled from sql table... list will vary based on selection...
e.g., When one is selected then display following items:
1] one
2] one one
3] one one one

I am new in php so please guide me how to make this happen or please provide a sample code....

Thanks and Regards,
Vaibhav

You can do this through AJAX.

Another way is
if page refreshing wont matter that much then you can simply pass the value to the query.

<form name="myform" id="myform" action="" method="get">
 
<select name="mydropdown" id="mydropdown" onchange="sortby_form.submit()" >
 
<option value='one'>One</option>
<option value='two'>Two</option>
<option value='three'>Three</option>
 
</select>
 
</form>
 

So when any value is selected from the dropdown menu, form will be submitted and the $mydropdown will be passed. You can use this value in your query.