TalkPHP - View Single Post

CMellor · 11-15-2007, 08:24 PM

Hey,

I want to make a poll script to use on my website, on the front page and the user's profile page (they can make their own), but I can't think how I'd set out the database structure for one.

I thought maybe having three tables:

poll_question
poll_options
poll_votes

... then join them all together with the ID's, or something like that. I've checked out other scripts' way of doing a structure, but it seems real sloppy to me some of the coding people do.

Any help is appreciated, if you've wrote a poll script before, maybe you could share how you did you structure in the database.

Thanks,

- Chris

11-15-2007, 08:24 PM	#1 (permalink)
CMellor The Acquainted Join Date: Sep 2007 Location: Leeds, UK Posts: 141 Thanks: 6	Database Structure for a Poll Hey, I want to make a poll script to use on my website, on the front page and the user's profile page (they can make their own), but I can't think how I'd set out the database structure for one. I thought maybe having three tables: poll_question poll_options poll_votes ... then join them all together with the ID's, or something like that. I've checked out other scripts' way of doing a structure, but it seems real sloppy to me some of the coding people do. Any help is appreciated, if you've wrote a poll script before, maybe you could share how you did you structure in the database. Thanks, - Chris __________________ Not quite a n00b...