how to get data from DB in php form?

[alan123]

I have two textbox in form, tbox1 and tbox2, tbox1 is a dropdown menu which collect data from db, I want tbox2 also retrieve the data from DB based on the tbox1's value, so when I click and select tbox1, it will update the value on tbox2, how I can set the form event in php page?

 

[sleipnir214]

Setting a form event is not a function of PHP. Form events are provided by client-side languages like JavaScript of VBScript.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[hos2]

perhaps this thread is wat you looking for
thread434-743971

 

[hos2]

oh and the working example is gone, I will look if I can retrieve it from somewhere

 

[alan123]

hos2, thanks for your posting, I have read your message at:

thread434-743971 have a question, in the code:

<select name=&quot;whbotid&quot; onchange=&quot;window.location.replace('example1.php3?whbotid='+ window.document.tektips.whbotid.value)&quot;><option value=&quot;&quot;>

I need to use $_GET[] to get those parameters from replaced url, actually I have many other parameters in the form and impossible to write in "window.location.replace('....')", is there a way to pass all other parameters? thanks in advance.