Donations VS Votes
Hi, my site allows donators (members) to make donations to charity competitions. The donators can also vote in a poll for each charity competition.
When a user makes a donation to a charity competition, they also have the right to submit one vote.
I want to change the system, so that the donators can make as many donations as they like to a charity competition but still only have one vote.
My current database looks like this:
vote_status (submitted / not submitted)
How should i setting this up so that users can submit as many donation as they like per competition but they are still only limited to one vote? Thanks in advance for your help...
Maybe separate votes and donations into 2 different tables?
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Couldn't you just allow entries to be added when they donate. The vote_status field could populate with something like "Already voted" and the vote_answer could be null?
I'm always up for networking with fellow web professionals. Connect with me on LinkedIn
if you like!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)