Hello,

I have this issue and would like some help on it.

1. I want to design a system whereby a person can register and the details get logged into MYSQL. ( I have done this )
2. The person can login and go to the members area, the username and password should be correct from the mysql ( Done this )

3. I want a administrator panel whereby i can have a form or any info, where i can pick the user from a dropdown list, and then add the following info to their records.

- Phone Number Called
- Minutes called
- Extension Called

Now there will be extensions like 0845, 0800 and others.

I want 0800 to be free and 0845 to be $1/minute so when i add the number of minutes called and the extension there should be a field in the mysql that gets updated with the calculation.

Then after all the input is done the mysql should be updated with the necessary records.

Also then when the user logs into his members panel he should see who he called within the last 10,20,30 days and how much is his charge.

I have only one database table for now which is setup as follows and is for the registration details.



Please assist.

Please reply if you have any questions or anything

Thanks & Regards
Sponge Bob Reviewed by Sponge Bob on . Update Client Record and Insert New Records Hello, I have this issue and would like some help on it. 1. I want to design a system whereby a person can register and the details get logged into MYSQL. ( I have done this ) 2. The person can login and go to the members area, the username and password should be correct from the mysql ( Done this ) 3. I want a administrator panel whereby i can have a form or any info, where i can pick the user from a dropdown list, and then add the following info to their records. - Phone Rating: 5