View Single Post
Old Jul 8th, 2007, 4:22 AM   #5
titaniumdecoy
Expert Programmer
 
titaniumdecoy's Avatar
 
Join Date: Nov 2005
Posts: 837
Rep Power: 3 titaniumdecoy is on a distinguished road
Send a message via AIM to titaniumdecoy
As I meant to suggest via the link in my last post, you can use database normalization techniques to brainstorm the most robust design for your database. I suggest you do some research on the subject.

As for your poll example, my solution would be: Create a users table (userid, username, etc.). Create a new table users_to_polls to associate each user with each poll they vote in (u2pid, userid, pollid, response). Create a new table for each poll (pollid, question, etc.).

Last edited by titaniumdecoy; Jul 8th, 2007 at 4:35 AM.
titaniumdecoy is offline   Reply With Quote