PHP / MySQL Gurus : Help me inside.

[galleryseek]

$query = "UPDATE `hgarticlerate` SET votes=votes+1, score='hgarticlerate.votes/($vote+hgarticlerate.score)' WHERE articleid='15'";

now I know this has to be wrong, because I've never done anything like it and I couldn't find anything on the net about it (and uhm, yeah i tried running it and it also doesn't work )

basically what i'm trying to do for field "score" is perform an average by first adding the current value of "score" (hgarticlerate.score) to the new vote submitted ($vote), and then dividing it by the votes field (hgarticlerate.votes)

i'm sure i just have the syntax screwed up, or I'm leaving out a function in mysql that will do this easier. help?

[vending_machine]

Your code would look like this (you have your arithmetic wrong for the score, you will have to fix that ;) ):

UPDATE `hgarticlerate` SET votes = votes + 1 , score = votes / ( '$vote' + score ) WHERE articleid = '15';

[galleryseek]

(you have your arithmetic wrong for the score, you will have to fix that ;) ):

how is it wrong??

thanks btw.