Query Inserting Wrong Number[Fixed]
Posted: Sat Feb 18, 2012 2:27 am
So, I'm trying to create viewable results for players to see of each arena round in my game.
Problem is, is that it's inserting the wrong arena number. It inserts 127, I have no idea where It's getting that number, I am echo'ing out the variable $arenanumber and it's showing the correct value 156.
Here's the query. (This is part of a multi_query)
The problem is with `arenanumber` and '$arenanumber'
How it's getting 127, is mindboggling
Problem is, is that it's inserting the wrong arena number. It inserts 127, I have no idea where It's getting that number, I am echo'ing out the variable $arenanumber and it's showing the correct value 156.
Here's the query. (This is part of a multi_query)
Code: Select all
$update .= "INSERT INTO `lwresults`(`gameround`,`arenanumber`,`round`,`pid`,`attacker`,`defpid`,`defender`,`damage`,`kill`,`heal`,`style`)VALUES('$arenainfo[gameround]','$arenanumber','$arenainfo[round]','$row[5]','$row[1]','$targetpid','$targetname','$damage','$kills','0','$style')";How it's getting 127, is mindboggling