|Can we set a constant number of votes per user ? |
for example, a user can only vote 3 times (3 different items)
|2013-03-27 17:28:32 - In reply to message 1 from Marios Pavlou|
Depends on how we will track users-per IP or via our own login system, we can extend table `vots` adding a column for IP/username, and (id,username) must be an unique key-this limits votes for a single product per user_name(because vots.id references to articles.id).
Also depend on how must be the system behaviour we can choose how to insert data into table `vots` (against its UNIQUE KEY (id,username)): by "insert ignore","insert...on duplicate key update" or even "replace into table..."