What is wrong with this UPDATE command??

[TheDust]

UPDATE a_albums SET ratingPts = (ratingPts + $formRating), ratingNum = (ratingNum + 1) WHERE albumID = $formAlbumID;

I'm trying to increase the values of two columns in "a_albums"... ratingPts gets increased by a variable returned from the user, and ratingNum gets increased by 1. Anybody know what I'm doing wrong here? Everything looks right... ?

 

[r937]

everything looks okay, except maybe the parentheses, not sure about those, you could take them out

otherwise, make your your variables are actual numeric values...


rudy

 

[Dan59173]

You didn't actually say what problem you were seeing with your UPDATE statment. Syntax itself looks OK. I assume that the statement is surrounded by double quotes " and not single quotes '. Does the record get updated at all? Any mySql error messages? Does $formAlbumID contain what you think it contains? I noticed that it isn't quoted, is it a numberic value? If not you will need to quote it.

Dan