$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?