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 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. Link to comment https://forums.phpfreaks.com/topic/89105-database-design-help/#findComment-456886 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.