updating tables in db

[scbmx]

im trying to update tables in mysql by using a select box with a form. im kinda new with php and i dont know how to display different data in the form bye doing this can anybody help or give me an example?

[ab4net]

what do mean .. ?
are u trying to make the form selection effects the table data results . ?
or what .. ?
please specify so we can help ....

[scbmx]

the selection box will have the possible rows that you can update in it, and onChange the form will contain all the data from that row...then a simple update query on the page. the part im have trouble with is the onChange select box to show the desired part of the table. thanks for anyhelp

[ab4net]

you can use this Javascript:

<script language="javascript">
function jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
</script>

and in the field of the form: SLECT ... use the :

onChange="jumpMenu('parent',this,0)

while doing that u can let the page post variables throught the form to the url ..
so it'll look like :

http://yourname.com/page.php?var=value

when u change the selection :

http://yourname.com/page.php?var=NEWvalue