(Help with pHp code) Please help!!

[sgarba]

Hello pHp gurus,
I am new to pHp and MySQL, and have a question to ask. I setup a HTML form to receive user data and save the data onto a MySQL table. One of the comboboxes "list" displayed on the form extracts and displays a list from another MySQL table. What I want and can not figure out is that, when a user selects one of the items from the combo box "list", I would like to run a query to extract data from another table and automatically display it on one of the fields of the HTML form. so that the user doesn't have to enter the data. (In some OO tools, I am sure you know this, that this is done through "OnChange" event etc). I tried the OnBlur, OnChange for the "list", and yet nothing worked.

The form so far can collect the data from the user and save onto the destination table, but the field I want to populate is still blank. I have tried everything, but to no avail. Could somebody please help me with something so that I can proceed on this project? Any help will be appreciated.

I spent sooooo many hours, and read over many books and nothing really clicked. Please save my sanity and my little head!!

I forgot to mention that I am using DreamWeaver with PhP as my serverside scripting language.😕

[paulnaj]

Hi sgarba,

PHP is a server-side script. 🙁 It delivers HTML to the browser. It cannot affect what happens after the HTML has been delivered. The onChange attribute (and onClick etc) is supposed to contain a client-side script like javascript.

In order to extract info from a db, say, then you would have to 'go back' to the server using a form submit button or a hyperlink with attached variables and use those variables to select the data and re-build the entire page.

I think you're going to have to understand this before you try to understand anything else :queasy:

Paul 🙂

[justsomeone]

You could try using different frames in your web page. When the user selects whatever from the dropdown list on frame A, an onChange event on that field triggers a refresh of the content in Frame B, the contents of which have been changed to reflect the options chosen in frame A.

[bradgrafelman]

Or simply use onChange to submit the form and have your script check to see if that element has been filled; if it has, run your query.