effective retrieve for a voting system in PHP and MySQL
- by Adnan
Hello,
I have a system where registered users can vote up/vote down comment for a picture. Something very similar to SO's voting system.
I store the votes in a table with values as such;
vote_id | vote_comment_id | vote_user_id | vote_date | vote_type
Now I have few a question concerned the speed and efficiency for the following;
PROB: Once…