I need to build a table and I am looking for the most efficient way to do it. The data I need to collect will come from multiple users all using the same input form. I need to extract the data to different html pages (about 50) but only the data that corresponds to the user of that particular html page. The fields I need are club_name and announcement. I really only need the user to input the club_name once since I don't want it to be redundant, but the users will be making announcement changes frequently.
What would be the most effecient system using php and mysql?
A. One table with the above fields and then create an edit/delete form the user could use to update data in announcement as necessary thereby not having to use an input form more than once. Instead the data in the table would be altered. Would I have to create a seperate php page for each club_name in order to get just the data for that club?
OR
B. Two tables with just one of the fields in each and then cross refrencing the two tables by club-name. By doing this, could I utilize just one input form and one edit form?
Can you show me or point me to an example for B. I can see how A works to get it to do what I want, but I can't wrap my mind around B to see how I could make it work. A seems to tedious to be efficient but it is linear, while B seems to abstract for me to work with.
Maybe someone could help.
What would be the most effecient system using php and mysql?
A. One table with the above fields and then create an edit/delete form the user could use to update data in announcement as necessary thereby not having to use an input form more than once. Instead the data in the table would be altered. Would I have to create a seperate php page for each club_name in order to get just the data for that club?
OR
B. Two tables with just one of the fields in each and then cross refrencing the two tables by club-name. By doing this, could I utilize just one input form and one edit form?
Can you show me or point me to an example for B. I can see how A works to get it to do what I want, but I can't wrap my mind around B to see how I could make it work. A seems to tedious to be efficient but it is linear, while B seems to abstract for me to work with.
Maybe someone could help.