PHP / MySQL Gurus : Help me inside. - GoFuckYourself.com

galleryseek · 03-05-2005, 10:14 AM

$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 · 03-05-2005, 10:28 AM

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

Code:

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

galleryseek · 03-05-2005, 10:44 AM

Quote:

Originally Posted by vending_machine

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

how is it wrong??

thanks btw.

03-05-2005, 10:14 AM	#1
galleryseek Confirmed User Industry Role: Join Date: Mar 2002 Posts: 8,234	PHP / MySQL Gurus : Help me inside. $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?

03-05-2005, 10:28 AM	#2
vending_machine Confirmed User Join Date: Jun 2002 Location: Seattle Posts: 1,062	Your code would look like this (you have your arithmetic wrong for the score, you will have to fix that ;) ): Code: UPDATE `hgarticlerate` SET votes = votes + 1 , score = votes / ( '$vote' + score ) WHERE articleid = '15';