[Resolved] how to increment in mysql query?

[helz]

i have a rating system with 6 different ratings:
rat_0 thru rat_5 and what i want to do is when the user specifies
which rating they want to choose 0 being bottom and 5 being the top
so when they chose a rating i want it to increment that field in the db i was thinking something along the lines of this but am not sure how to do it:

if ($rating == 0) {
   $ammendrating = mysql_query("UPDATE tablename SET rat_0++ WHERE id=$id");
}

im pretty sure its wrong

will i need to do another query to get the previous amount then increment it then update the table?

[cahva]

if ($rating == 0) { 
   $ammendrating = mysql_query("UPDATE tablename SET rat_0=rat_0+1 WHERE id=$id"); 
}

[cahva]

If you want to avoid the if's then you can do it with only one.

if ($rating==0 || $rating==1 || $rating==2 || $rating==3 || $rating==4 || $rating==5) {
$ammendrating = mysql_query("UPDATE tablename SET rat_".$rating."=rat_".$rating."+1 WHERE id=$id");
}

[helz]

that second option looks great, thanks alot

would it have to be +1 or would ++ work?
doesnt matter, this is just for curiosity 🙂

[cahva]

Mysql doesnt have that "++" like other languages.

[helz]

okies ta