I am having a problem getting it into my mind how to use MYSQL functions in a PHP program. The correct syntax when do I need to use ( ), [ ]. { } ect. I have read, looked at examples and it is still not clicking in my mind. I am just wondering if someone has a simple explanation guide lines, ect.
I come from the old RPGII, COBOL, ECT(I am also old), and trying to relate the new world back to the old...... Here is hoping someone...
Roger Fain
Last Activity: Feb 19 '11, 02:08 PM
Joined: Feb 1 '11
Location:
-
Could some explain the syntax of MySQL functions in PHP?
-
Roger Fain replied to How to update the game count within a query if the Raw Score is greater than 0?in PHPI am sorry.........I am getting a syntax error on the if statement -
Roger Fain started a topic How to update the game count within a query if the Raw Score is greater than 0?in PHPHow to update the game count within a query if the Raw Score is greater than 0?
this is inside phpCode:$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.";
No activity results to display
Leave a comment: