[RESOLVED] Help using a loop inside mail function

[denzlite]

$sql="Select * FROM data08";
$data_set = mysql_query($sql, $connection);

while($data=mysql_fetch_array($data_set)) {	
     echo "<p>Review ID: {$data["cgea_id"]} </p> \n";	
}		

So this works to display a list of items on a webpage - so if I wanted to include his same list in an email using PHP mail function - how would I do that? I've figured out how to send the emails and everything, I just can't figure out what I use in place of echo to get the loops to work so I can email people data....

Thanks...

[coldwerturkey]

you would make a variable and define it outside the loop like $message = "";, then within the loop use $message .= "<p>Review ID: {$data["cgea_id"]} </p> \n" (the .= adds to the variable)

than your mail function would look like mail($recipient, $subject, $message, $headers);

[denzlite]

Ok, yes, thanks that works when there's only one set of data per query.

But now - is where the loop problem gets weir for me. If you look at the code below, I need to get and email potentially several reviews per submission id....

	$sql="SELECT *
		FROM submissions";
	//Initial Submission Query
	$submissions = mysql_query($sql, $connection);
	confirm_query($submissions);	
	while($sub = mysql_fetch_array($submissions)) {
		//email stuff and headers... got this working...
			$sql2="Select * FROM data08_re WHERE sub_id=" .$sub['sub_id']. " ";
			$data_re_set = mysql_query($sql2, $connection);
			confirm_query($data_re_set);
			while($data_re=mysql_fetch_array($data_re_set)) {
                        //begin review

			$output = "Review ID: {$data_re["re_id"]}\n";
			$output .= "Problem Statement: {$data_re["problem"]}\n";
			$output .= "Strength of Research Design: {$data_re["strength"]}\n";
			$output .= "Data Collection: {$data_re["data"]}\n";						
			$output .= "Results: {$data_re["results"]}\n";
			$output .= "Conclusion: {$data_re["conclusion"]}\n";
			$output .= "Comments:{$data_re["comments"]}\n";					
		}
	//now do the mail funciton....
	mail($email, 
	"blah blah blah blah :::: Below are two or three reviews....
	$output", 
	$headers);			
}

This works when I'm echoing to webpage - but yes, the output variable will always be overwritten by the last review to pass through right??? hmmmm....

[coldwerturkey]

like i said

define it outside the loop like $message = "";, then within the loop use $message .= "<p>Review ID: {$data["cgea_id"]} </p> \n"

[denzlite]

i am a freaking idiot

thnks man