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! 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... Link to comment https://forums.phpfreaks.com/topic/70425-php-image-rating-system/#findComment-353856 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.