<?php
$query120 = "(SELECT username FROM friendship WHERE frenusername='{$username2}') UNION (SELECT frenusername FROM friendship WHERE username='{$username2}')";
$result120 = mysql_query($query120,$connection) or die (mysql_error());
confirm_query($result120); 
while($userinfo120 = mysql_fetch_array($result120)){
    $frenusername2= $userinfo120['username'];
    echo $frenusername2;
}
?>

The output show the result of both select queries. Why $frenusername2 has the value of $userinfo120['username']; and $userinfo120['frenusername']; both?

Originally asked by: zac1987 on Stack Overflow