Generate data from the database

[heshan]

Hi all,

 

This is something related with php as well as java script. If anyone can help me regarding this issue i would be very pleased.

 

In a particular form, i have 2 fields namely customer id and Account type. Since there are many account types it is stored as a jump menu.

 

There are seperate tables in my database to represent each of those accounts types. There is a seperate field in each table called account number which is auto incremented.

 

If i select a particular account type in my form, i want to get the account number which is relevant to that account type. For an example if i click the submit button a message should appear like

" A new ..........( relevant account type) has been successfully opened"

 

Any idea of how this could be done?

 

Thanks,

Heshan.