How to update the game count within a query if the Raw Score is greater than 0?

[Roger Fain]

$res = mysql_query("UPDATE Player_Master, Round1
 	SET Player_Master.Total_Raw=(Player_Master.Total_Raw)+(Round1.Player1_Raw),
		if Round1.Player_Raw > 0 Player_Master.Games=(Player_Master.Games+1)
    WHERE Player_Master.Player_ID=Round1.Player1_ID")or exit( mysql_error() ) ; 
 if( $res ) echo  " Round1 Player1 Done.";

this is inside php

[Markus]

What is the problem?

[Roger Fain]

I am sorry.........I am getting a syntax error on the if statement

[Rabbit]

I was under the impression that IF is supposed to be a function of the format IF(expression, true value, false value)