Looping issue

[inspireddesign]

Hello All!

 

I have a simple loop that will loop through the database and return the values in a string.  My problem is that only the last row is the database is echoed not the multiple entries I expect.  I tried to place a Break but it produced the same result.  Can someone help?  Thanks!

 

<?php
	do {

    $msg  = ">> ". $row_act['activity'] ." - ". $row_act['insured']. " - " .$row_act['notes'] ."\r\n\n"; 

	break;	

	} while ($row_act = mysql_fetch_assoc($results));

?>

[Ken2k7]

My guess would be the break you have in the do. Also the variable $msg is being overwritten each iteration.

[ignace]

that's because when you use this:

 

<?php
$msg  = ">> ". $row_act['activity'] ." - ". $row_act['insured']. " - " .$row_act['notes'] ."\r\n\n"; 
?>

 

you always overwrite the contents of $msg therefor use this:

 

<?php
$msg  .= ">> ". $row_act['activity'] ." - ". $row_act['insured']. " - " .$row_act['notes'] ."\r\n\n"; 
?>

 

notice the . (dot) which concatenates strings

[inspireddesign]

Thanks!  That's got it, without the Break of course.