you may also want to throw in a voted by and record their ip into it
so they cant keep voting.
On Thu, 9 Sep 2004 07:38:38 -0400, Daniel Kessler <[EMAIL PROTECTED]> wrote:
> I'm doing a poll and determined this morning that I should use a
> relational DB. It's pretty basic, but it is my first one
>you may also want to throw in a voted by and record their ip into it
>so they cant keep voting.
I thought of doing that, but it would exclude community computers and since many of our audience is low-income, alot of their access is community-oriented.
So otherwise, I'm doing the right thing and
I'm also working on a poll systems and I decided to keep the number for each option in the same table as the option and just increment the value for example
id_poll (fk)
id_poll_option (pk)
poll_option
poll_option_description
poll_option_votes
if you are going to put the votes in a seperate table
> I'm also working on a poll systems and I decided to keep the number
> for each option in the same table as the option and just increment the
> value for example
>
> id_poll (fk)
> id_poll_option (pk)
> poll_option
> poll_option_description
> poll_option_votes
>
> if you are going to put the v
Looks good to me, here is a layout from one I did
tbl_Polls
PollID autonumber PK
PollQuestion text
DateAdded date/time
PollStatus number
tbl_PollAnswers
AnswerID autonumber PK
PolID number
SortID number
Tbl_PollResults
ResultID au
This crap is getting annoying
>Your message is a reply to anothers post and is more than 100 lines of
text. Unless you are
>a major writer, your probably adding a lot of the previous replies. Please
trim your posts
>when replying. Thank you.
Looks good to me, here is
>But then wouldn't I be writing an entry in the pollDB for every time that it's answered?
>So, when I make a poll, I write an entry for every different option/answer available. Then I also write an entry for every answer made? Am I understanding correctly?
>It doesn't seem like a good use of DB s
I'm building a polling app into my cms right now. Sorry but I haven't
built the Oracle versions of the table installers yet, but I can use
the mySQL versions cuz its the simplest sql to post. If this can
help, great. If anyone has any comments on my design I'd appreciate
them as this is a work i
So now I'm trying to create in Oracle the tables for the poll. But when I try to create the first one, which references another table, I get the error, "missing right parenthesis". The only other relational work that I've done was in mySQL so I'm sure that it's a syntax or keyword Oracle issue.
9 matches
Mail list logo