I have a simple ratings system setup on my site which I use to let users rate an article on a certain scale. I've also got a members database setup, and voting is restricted to members only.
I've been reading some threads on this forum about preventing cheaters from voting more than once and all of them seem to mention that this can be done by requiring users to login before voting (which as I mentioned, I already require). I'm just wondering how this works? I guess I would have to store the ID of the member someplace, but where?
The way I see it is, I can't store it in the 'Ratings' table that I have setup, because if I had a column called 'Voters', it would have multiple entries. And if I had a colmun called 'Articles_Rated' in my 'Members' table, the same problem would occur.
Is it necessary to setup a new table to make this work? I think that would work... but it would end up being a huge table once I get a lot of voters. Or is there something that I'm missing?