Getting HTML code in a variable

Anon

Hi all,

I have a while loop running, but I want to get the output of that variable in one variable called $table

The while loop is

while(list($cart,$sku,$name,$price,$date,$quantity,$total,$options)=mysql_fetch_row($result))

{

$gtotal+=$total;

}

The result is of course a table which displays the name, quantity, price and total of all items, so if there are one million thousands items there will be created a table with the info of all those items.

How do I get this entire table code (in HTML) into a variable?

The main reason why I want to do this is because I want this table to appear in an e-mail, and within the mail function it's not possible to run a while loop.

Any suggestions?

Thanks!

Anon

You seem to have the basic idea, unless your question is one of syntax. String concatenation uses "." instead of "+", so the basic form would be while (foo) {$html .=blah blah
}
mail ($to_address, $html);

Anon

Basically what the last post said but here it is more clearly:

while(list($cart,$sku,$name,$price,$date,$quantity,$total,$options)=mysql_fetch_row($result))

{

$gtotal+=$total;

$html .= '<table>';
$html .= sprintf('<tr><td align=center>%s</td>', $name);
$html . = '<td width=10> </td>';
$html .= sprintf('<tr><td align=center>%s</td>', $quantity);
$html . = '<td width=10> </td>';
$html .= sprintf('<tr><td align=center>%s</td>', $price);
$html . = '<td width=10> </td>';
$html .= sprintf('<tr><td align=center>%s</td>', $total);
$html .= '</tr></table>';

}
Now $html contains the whole shebang

Anon

I am trying to do the similar thing. However, it only works when the content is within a certain size. When my table gets larger, email is displaying correctly. Just wondering if there is a size limit on what you can display? If there is, how can I set it larger?