Hello, I would like to make an adress book app. I got the skills to achieve this goal in PHP. However I have a problem. I have no idea about how to let user add multiple phone numbers, addresses, emails etc just like in today's mobile phones. How can I do this? I mean, how shall I design the DB in order to achieve this? Arrays? Or another table to store these datas and get the record count when showing phone number boxes etc? What would you suggest? Thank you very much for your ideas, highly appriciated.
You could create a table called users which stores basic login info (userid, email address, password, Name, Last Name) and then create seperate tables for details there may be several entries for e.g. (street, street2, city, postcode, country) and (telephone) using "userid" to pull all the tables together. SELECT * FROM addresses WHERE userid = '1' would result all the recorded addresses for user with id 1 which would allow you to have 1 user but several addresses