OnChange and MySQL

[Anon]

Hello,

It's only a couple of weeks that I'm using PHP and MySQL, and I must say: it's fantastic! But now I've got a question...

I've build a form with a SELECT-box with several options. The result of an option is an ID (integer).

With an OnChange I want to lookup the ID in a table and return the description of the ID, as found in the table.

For example: in the SELECT-box the user chooses for "Don Johnson" with ID: 15. The OnChange kicks in and must locate ID 15 in the ACTORS-database and thus return "Miami Vice"...

How do I do this ???

Perhaps somebody has an example...

Thanks,
Hein.

[jjoske]

On change is a javascript which is processed on the clients computer while PHP is sever side which is processed on server. To get information from the actors table on a on change event you have two choices you could either pre load the table into the page and print it out via javascript, would work if the table was small, but would be impratical if it had more than 10 or 20 entries, or include a submit action with onchange event and print a new page using PHP.