Relationship with Tables MySQL

Question

Hello,

I have some small issue with relationships with tables as below:

I have created a login and registration script which has the following

table name: members:
fields: member_id, firstname, lastname, login, password

Now i have made another table with this

table name: phone
fields: member_id, phoneid, name, number, prefix, time,total

I want to make a form whereby a admin can select the name of the client from a drop down list, and then add a record such as the number called, number prefix, total time and the amount for that period.

I dont know how to do this, please help me by creating a script or help me how to go about this.

So all the time a admin makes a form on Client A it gets added to a new row on the phone table, then i will just add a call script on the client side where they can see all the records that they have done.

Thanks please assist.

Regards

Answer 1

Your db design seems fundamentally flawed - the is no association between the members and the phone_numbers tables. Add a FK (member_id) to phone_numbers table.

Regards creating the front-end, there are quite a lot of libraries that have data stores (we use ExtJS), and upon flushing the store you can do the persistence with php.

Hope this helps!

Answer 2

Please assist someone...