problem in checking account balances

Expand Post »

Hi,

I have 4 account type tables.

savings_investment(ID,account_type,full_name,balance,interest,customer_id)
shakthi(ID,account_type,full_name,balance,interest,customer_id)
surathal(ID,account_type,full_name,balance,interest,customer_id)
abhimani_plus(ID,account_type,full_name,balance,interest,customer_id)

The ID is different from one table to another. That is why i created 4 tables rather than one table.

I want to write the coding to check account balances. That is if user types the ID and clicks on search button the relevant details regarding that account should be shown in a table. That is account_type,full_name, balance, interest and customer_id.

Can anyone give me the relevant coding...

Thanks,
Heshan

Similar Threads

bank account in C++
bank program help needed in C++
Another Bank Account class in C++
Interest and Charges problem in Bank Account Project (revised). in C++
Interest and Charges problem in Bank Account Project. in C++

heshanm

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

145 posts
since Aug 2010

Permalink

Aug 31st, 2010

Re: problem in checking account balances

I think you're missing a field in your tables. I think after ID you need CUSTOMER_NUMBER and CUSTOMER_NUMBER should be the same for each account and should be the ID from the customer record.

ppetree

Reputation Points: 12

Solved Threads: 8

Junior Poster

Offline

157 posts
since Oct 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Multiple CheckBox

Next Thread in PHP Forum Timeline: PHP/MySQL Mailing List problem

DaniWeb Message

Cancel Changes

User Name
Password