getting data from while loop into string

[strange1]

I'd like to get data from a mysql_query into one single string, i.e.

$data = mysql_query("SELECT * FROM table"); 
while ($row = mysql_fetch_object($data)) { 
$row->data1.$row->.data2.$row->data3 ... 
}

So how do I get all the data that is being fetched within the while loop into one string outside of the loop?

if I put $data = $row->data1... it gives me an error.

thx for any help.

[Natty_Dreadlock]

hi, do it like this:

$string = "";
$data = mysql_query("SELECT * FROM table");  

while ($row = mysql_fetch_object($data)) {  

$string .= $row->data1 . $row->data2 . $row->data3 ...;  

}

$string should now contain the information u want.
hth

[tekky]

$string = '';
$data = mysql_query("SELECT * FROM table");  

while ($row = mysql_fetch_object($data))
{  

  $string .= implode('', $row);  

}

a little less code.... and typing if your rows have lots of columns 😉