11.12.2011, 18:18
No, I want to select the 'name' column where var1 is greater than one and var2 doesn't equal 1. I want to then store that result and loop through everyone who matches those circumstances on var1 being greater than once and var2 not being 1 and put their name in the pNm variable. Then I want to get the var1 of the player where the name is equal to pNm and I want to fetch that to the variable convert, and then the variable var is a converted version of the variable convert because I want it to turn out as an integer, not a string. Then I want to send a query to update players and set var1 to var1 minus 45 where the name is pNm and var2 isn't 1.