blinks Posted April 9, 2011 Share Posted April 9, 2011 I'd appreciate any assistance with the following code. When I echo the output, all the variables are correct, except that pokemon_pos is always 1, whereas it should be something like 49, which is the highest value in either tables trade_offers or pokemon_trainer for a given pokemon_trade_id. $getdeclined="SELECT * FROM trade_offers WHERE pokemon_trade_id=$_GET[id]"; $declined=mysql_query($getdeclined); while ($row = mysql_fetch_array($declined)){ $getdecusername="select max(pokemon_pos) from ( select max(pokemon_pos) as pokemon_pos from pokemon_trainer WHERE pokemon_trainer = '$row[pokemon_trainer]' union all select max(pokemon_pos) from trade_offers WHERE pokemon_trainer = '$row[pokemon_trainer]' AND pokemon_trade_id = $_GET[id] ) as x"; $decusername=mysql_query($getdecusername); while ($row2 = mysql_fetch_array($decusername)){ $newpos = $row2['pokemon_pos']; $newpos +=1; } $update="UPDATE trade_offers SET pokemon_pos = $newpos WHERE pokemon_id = $row[pokemon_id]"; $result=mysql_query($update); } Link to comment https://forums.phpfreaks.com/topic/233227-sql-variable-is-undefined/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.