MySQL Looping
#6

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.
Reply


Messages In This Thread
MySQL Looping - by SuperViper - 11.12.2011, 17:54
Re: MySQL Looping - by GamingTurf - 11.12.2011, 17:58
Re: MySQL Looping - by SuperViper - 11.12.2011, 17:59
Re: MySQL Looping - by GamingTurf - 11.12.2011, 18:08
Re: MySQL Looping - by Kingunit - 11.12.2011, 18:09
Re: MySQL Looping - by SuperViper - 11.12.2011, 18:18
Re: MySQL Looping - by Hiddos - 11.12.2011, 18:21
Re: MySQL Looping - by SuperViper - 11.12.2011, 18:24

Forum Jump:


Users browsing this thread: 3 Guest(s)