By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,723 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,723 IT Pros & Developers. It's quick & easy.

user table

pradeepjain
100+
P: 563
Hii guys,
i want to create a table when a user registers with our site a table must be created for him and then after that when he submits his abstracts it must create a new row fro each abstract.Is this possible



thanks,
Pradeep
Sep 30 '08 #1
Share this Question
Share on Google+
4 Replies


chelvan
P: 90
hi
welcome

why not? its possible

chel-1
Sep 30 '08 #2

10K+
P: 13,264
Now that your question has been answered ... er ..
how many users are you expecting and how many "abstracts" per user are you expecting?
Perhaps you could just use one abstracts table with a user_id as a foreign key?
Sep 30 '08 #3

pradeepjain
100+
P: 563
hii,
A user can submit any number of abstracts .so only the problem.I have a small idea which i am working on i.e When a user registers with the site he is given an ID so when he registers we store all the information in table and then create a table with ID as table name with some default fields .And when the user submits the abstract we keep on adding rows per abstract.So is there any improvement to this


thanks,
Pradeep
Sep 30 '08 #4

Markus
Expert 5K+
P: 6,050
I would have a user table and an 'abstracts' table. The user table contains a unique ID and the users name, and the 'abstracts' table contains the ID of the user and the 'abstract' itself. That way, you don't clog up your mysql database with loads of unnecessary tables.
Sep 30 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.