how Do i echo userName and user2name from two diffrent tables in while loop

Question

I have Two Tables userwhich has field userName and another table page which has field pageUserName so im selecting this two tables form the database in while loop but i want to echo this two Names in same while loop one after another like we have in FB their are userName as Well as Page names in news feed how can i do this ????

    <?php  
    $sql=mysql_query("SELECT * FROM user LEFT JOIN page ON user.userID=page.userID") ;
    while($row=mysql_fetch_assoc());
    {
    //For First Loop It Should Be UserName
    echo $row['userName']; 

   //For 2nd Loop It Should Be pageUserName
    echo $row['pageUserName']; 

    } ?>

This is the code but the echo gets print together i want separate echo for userName and another for pageUserName one after another and not together

Answer 1

Try like this:

<?php
$sql = mysql_query("SELECT * FROM user LEFT JOIN page ON user.userID=page.userID");

while ($row = mysql_fetch_assoc()) {
    echo $row['userName'] . " " . $row['pageUserName'] . "<br>";
}
?>

NOTE

You should not use open / end php tag in each row.

You can concatenate your string with . character as in my example.

WARNING

mysql_* functions are deprecated, use mysqli_* or PDO instead.

UPDATE

Based on OP edit in his original question, I think I get it what he wants. When you iterate through your results, instead echo put them into 2 arrays.

Then iterate through both of them. I write for this a little function called showNames, so you avoid code repetation.

function showNames($array) {
    foreach ($array as $item) {
        echo $item."<br>";
    }
}

//Init arrays
$userNames = [];
$pageUserNames = [];

while ($row = mysql_fetch_assoc()) {
    //Put values into the 2 arrays
    $userNames[] = $row['userName'];
    $pageUserNames[] = $row['pageUserName'];
}

//Show the items of arrays
showNames($userNames);
echo '<hr>';
showNames($pageUserNames);

Answer 2

<?php  
$sql=mysql_query("SELECT * FROM user LEFT JOIN page ON user.userID=page.userID") ;

while($row=mysql_fetch_assoc());
{
    echo $row['userName']." ".$row['pageUserName']."<br />";
} 
?>

Answer 3

inside loop make a single line as follows:

<?php echo $row['userName']. " - ". $row['pageUserName']."<br>" ?>

Answer 4

You mean this?

<?php  
  $sql=mysql_query("SELECT * FROM user LEFT JOIN page ON user.userID=page.userID") ;
  while($row=mysql_fetch_assoc())
  {
    echo $row['userName'] . ' ' . $row['pageUserName'];
  }
?>