Grab onchange drop down list value and store in DB

[chinto09]

Hi
I have a drop down list of user's role where Admin can assign role to a user.
What i want is that when admin select a value from drop down list, this value will be stored in my db.

<form action="" method="">
<select name="change_role" id="change_role">
<option value="1">Admin</option>
<option value="2">Moderator</option>
<option value="3">Register user</option>
</select>
</form>

i think i have to use Javascript on change event, but how how to grab value for php script is not known to me.

If anybody helps me quickly??
thanks in advance

[NogDog]

What you're describing sounds like a job for AJAX (asynchronous communication between javascript and the web host). Here's the Google result for "PHP AJAX tutorial".

[sheikhmdirfan]

what u can do is that u can call a javascript function on the onchange event of the dropdown list..

In that javascript u can check if the selected value is admin then u make a call to another php file making use of the http object in javascript..

In the php file u can insert that value to the Db and return back to the javascript function and if u want then display a message that detail was saved...
then u can use an alert message for that...