making WHILE to a variable

[dotJoon]

code

$testResult=mysql_query("select id, name from myTable order by id ") ; 

while($row = mysql_fetch_array($testResult))
{

$myRecord="(". $row['id'].")".$row['name']." <br>";

echo $myRecord;

}


result

(id) name

(1)  Tom 
(2)  Mary 
(3)  Jane 
(4)  Jack

The code above produces the result above.

I like to get the same result above by using one variable named "myWholeResult".

The code below which is one of trial for it doesn't work correctly, but I hope it shows what I want.

trial code

$testResult=mysql_query("select id, name from myTable order by id ") ; 


$myWholeResult = while($row = mysql_fetch_array($testResult))
{

$myRecord="(". $row['id'].")".$row['name']." <br>";

echo $myRecord;

};

echo $myWholeResult;

target result

(1)  Tom 
(2)  Mary 
(3)  Jane 
(4)  Jack

[dotJoon]

The trial code2 below can get what I want with A variable, but I guess there might be easier way for it.

trial code2

$myWholeRecord="";

$testResult=mysql_query("select id, name from myTable order by id ") ; 



while($row = mysql_fetch_array($testResult))
{

$myRecord="(". $row['id'].")".$row['name']." <br>";

$myWholeRecord=$myWholeRecord.$myRecord;
}


echo $myWholeRecord;

[programthis]

Change the code inside your while block to

while($row = mysql_fetch_array($testResult))
{
    $myWholeRecord .= "(". $row['id'].")".$row['name']." <br>";
} 

.= will append data to an existing variable.

[dotJoon]

Thank you very much, programhis.