How to generate data from the database
Posted: Wed Aug 11, 2010 11:02 am
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.
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.