PHP: Changing the query variables during the while loop

[Eonwe]

I was hoping to change one of the variables of a query, from inside the while loop, is it possible to do this? EG.\[code\]$query = mysql_query('SELECT column1, column2 FROM table1 WHERE column1 = "'.$variable.'";', $conn);while ($data = http://stackoverflow.com/questions/2062701/mysql_fetch_assoc($query)) { if($data['column2'] == 'original') { $variable = 'altered'; }}\[/code\]I just want to see if this is possible, or is the $data array already fully generated, before stepping through the while statement?Thanks