CodeToad Posted September 24, 2007 Share Posted September 24, 2007 I'm trying to create a voting system so that users can rate an image on my site 1-5 and keep that info in the database but I'm stuck... I already have my image file names, descriptions, etc being pulled from a database, so I'd like (I think) to use a second database to keep track of the number of one's, two's, etc that have been assigned to the image's primary key. I have a database set up with: -image id (primary key) -number of votes (add 1 each time submitted) -average (recalculate each time submitted) -one (add one if user votes for this) -two (add one if user votes for this) -three (add one if user votes for this) -four (add one if user votes for this) -five (add one if user votes for this) Is this the right idea? The problem I'm running into is that I don't know how increase the value using "INSERT INTO" the correct column... Am I not going about this in the best way? ANY insight/help/suggestions/comments would be massively appreciated! Quote Link to comment https://forums.phpfreaks.com/topic/70425-php-image-rating-system/ Share on other sites More sharing options...
JJohnsenDK Posted September 24, 2007 Share Posted September 24, 2007 you should use a table that stores all individual votes and refer them to the user by their userID vote_imageID - 1 imageID - 5 userID - 10 vote_imageID - 2 imageID - 5 userID - 3 and so on... Quote Link to comment https://forums.phpfreaks.com/topic/70425-php-image-rating-system/#findComment-353856 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.