How To Display This Data In Rows:

[roldahayes]

Hi,

 

This code returns 2 table fields. "code" then "name"

 

all works well until 2 or more rows are retuned and then it displays in one long line....

 

How can I get it to display each line separately?

 

$message   .= $row['code'] ."   -   ".  $row["name"];

[White_Lily]

Post the code for the whole loop and then we can help you properly.

[roldahayes]

if(mysql_num_rows($result) >= 1)
{

 $email = 'mymail@gmail.com';
 $subject = "LOW STOCK WARNING!";
 $message = "One or more products are running low:\r\n\r\n";
 while($row = mysql_fetch_assoc($result))
 {    
 $message   .= $row['code'] ."    -   ".  $row["name"];

 }
 if(mail($email, $subject, $message))
 {
       //mail successfully sent
 }
 else
 {
       //mail unsuccessful
 }
}

[Christian F.]

Add a newline ("\n") to the end of the string, inside the loop.

[roldahayes]

Thanks I see where I was going wrong,

 

I've fixed it with:

 

$message .= $row['code'] ." - ". $row["name"]."\n";

Edited November 23, 2012 by roldahayes