Poddy Posted February 2, 2008 Share Posted February 2, 2008 Hello, i am currently building a web application for facebook with PHP and MYSQL my issue is that i need a table that can contain the user id along with the values he enters in a specific form to numerous questions. the number of questions is dynamic and i need to to know what the user wrote, so it cant be a true or false thing.. should i create a table for each user and then just insert the questions id's with the value in it? is that efficient enough? or is there another way, more bandwidth effective? i also thought of making a table of user_id and answer while answer contains the values the user submitted as red,green,blue,yellow and etc. thanks in advance for any help Quote Link to comment https://forums.phpfreaks.com/topic/89105-database-design-help/ Share on other sites More sharing options...
Daniel0 Posted February 3, 2008 Share Posted February 3, 2008 Don't create a table for each user. Just make a column called user_id in the question table. Quote Link to comment https://forums.phpfreaks.com/topic/89105-database-design-help/#findComment-456886 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.