Display multiple data from mysql table in one line?

[freaker87]

i have a mysql table which contains name like

 

mid          mname

 

101          AAA

102          BBB

103          CCC

 

now i have to print this name in a html table like AAA, BBB, CCC

 

i am getting this by while loop in a variable but when loop changes then value also change so please tell me how i get this only in one variable & print

[dragon_sa]

show us the code you are using to do the while loop

[freaker87]

        $qry = "select * from memaster";

       

        $result = mysql_query($qry,$link);

       

        while ($row = mysql_fetch_array($result))

       

        {

            $mid = $row['mid'];

           

            $mname = $row['mname'];

 

        }

 

echo "<td> $mname</td>";

 

this is i am using......

[Muddy_Funster]

Use something like the following:

$sql = "SELECT mname FROM tableName";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result){
$myArray[] = $row['mname'];
}
$myList = implode(', ', $myArray);
echo $myList;

[freaker87]

It works...

Thanks Muddy.....