G
Garion W
Guest
I am wanting to create a karma system in PHP, powered by a mysql database. I want registered users only to be able to rate content either up or down, but they can only vote once.
What is the best way to store this information. The only proper way I can think of is having a table which records the users id, the id of what they are rating, and what they rated it. However I can see that taking up quite a few too many rows.
Does anyone else have any other ideas/suggestions?
SedativeChunk - Thanks for that, the other way I thought about doing was by storing all users who had voted yes in an array, and all who had voted no in an array, and doing it that way.
What is the best way to store this information. The only proper way I can think of is having a table which records the users id, the id of what they are rating, and what they rated it. However I can see that taking up quite a few too many rows.
Does anyone else have any other ideas/suggestions?
SedativeChunk - Thanks for that, the other way I thought about doing was by storing all users who had voted yes in an array, and all who had voted no in an array, and doing it that way.