statement in variable

Brusca

Hi Guys,
I am building a page which sends an html email to members on my list. I have all the details of that and the send sorted. I am having a small problem with the content to send. The content to be sent is stored in a variable called '$body'.

$body = "<html>my html is to go here</html>";

Problem is I have to put results from a database in that variable. Sometimes there is more than one result. I have no prolems with retrieving the results I would like I just have no idea how to get them into my '$body' variable.

Cheers

Brusca

tis ok. I have just gone and answered my own question

Cheers

Mordecai

[Edit]Well, I typed all this before you posted back, but I'll leave it here for anyone else with this problem. Remember to mark the thread resolved by clicking the link below.[/Edit]
Since you didn't give any code for what you have, I'll just be able to give you a brief mockup:

$result = mysql_query('your query');
while ($row = mysql_fetch_row($result, MYSQL_NUM)) {
  $body.= "some HTML".$row[0]."some more HTML...";
}

Something like that should suffice. The "." is the concat operator (concatenation means connect), used to put two strings together.