Hi. I am creating a database where a user can store up to 50 names of their family members. I have two table structures in mind and curious which one is the more efficient structure for using with php.



Note:(the columns would repeated until the fiftiethfamilymemberid and fiftiethfamilymembername for a total of 101 columns)


which is more efficient when using php... Table A which would have more columns but less rows or Table B which would have less rows but more columns.. also keep in mind that the fixed amount is 50 family members per a user. Thanks in advance.

almostbob commented: Thanks, to find a new poster who has begun their work before they ask, and its not a Do It For Me, question. +13

Recommended Answers

All 3 Replies

Member Avatar for diafol

I suggest two related tables...

**users** (user_id [Primary Key] | username | pw ...)
**ff** (ff_id | user_id [Foreign Key] | ffname | ffnumber)


SELECT ff_id, ffname, ffnumber FROM ff WHERE user_id = 7

I doubt whether users want to create a new unique familymember record every time they want to add a member - keep it simple. Just a name and a number.

Member Avatar for diafol
INSERT INTO ff (name, number) SELECT DISTINCT :name AS name, :number AS number FROM users WHERE (SELECT COUNT(user_id) FROM ff WHERE user_id = :user_id) <= 50

This is a workaround (the select distinct clause), and will only insert a record while a users number of family/friends is <= 50.

thanks alot :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.