PHP image rating system

[CodeToad]

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!

[JJohnsenDK]

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...