Please help PHP n00b email something

[FTN BLZZRD]

Alright...well, I'm very new to PHP and this is my first little script I'm doing for work. I have EVERYTHING working....

• User Enters Information On Form
• Form takes information and stores in MySQL
• There is also a page to display the MySQL results in a table

Here is the result table....

        <TBODY>
    <?php
//Client Loop
$i=0;
while ($i < $num_rows) {

$id = mysql_result($query,$i,"id");
$date = mysql_result($query, $i, "date");
$rooms = mysql_result($query, $i, "rooms");
$tax = mysql_result($query, $i, "tax");
$misc = mysql_result($query, $i, "misc");
$total1 = mysql_result($query, $i, "total1");
$cash = mysql_result($query, $i, "cash");
$bankcard = mysql_result($query, $i, "bankcard");
$amex = mysql_result($query, $i, "amex");
$directbill = mysql_result($query, $i, "directbill");
$total2 = mysql_result($query, $i, "total2");

echo "<TR CLASS=\"MYTABLE\">";
echo "<TD CLASS=\"MYTABLE\">" . $id . "</TD>";
echo "<TD CLASS=\"MYTABLE\">" . $date . "</TD>";
echo "<TD CLASS=\"MYTABLE\">" . $rooms . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $tax . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $misc . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $total1 . "</TD>";
echo "<TD CLASS=\"MYTABLE\">   </TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $cash . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $bankcard . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $amex . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $directbill . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $total2 . "</TD>";
echo "</TR>";
$i++;
}
mysql_close();
?>
    </TBODY>

This will obviously create multiple rows based on how many results there are. Which then makes a full table of multiple rows.

I now want to send this FULL table (all results) via email using PHP. How can this be done? Any links would be really appreciated.

 

[aras]

If i understand you correctly, you are going to get those data as a text and e-mail it? You can record the output buffer before sending it to browser, and use the same template to e-mail.

<?PHP

ob_start();   // start here

echo '<TBODY>';
    
//Client Loop
$i=0;
while ($i < $num_rows) {

$id = mysql_result($query,$i,"id");
$date = mysql_result($query, $i, "date");
$rooms = mysql_result($query, $i, "rooms");
$tax = mysql_result($query, $i, "tax");
$misc = mysql_result($query, $i, "misc");
$total1 = mysql_result($query, $i, "total1");
$cash = mysql_result($query, $i, "cash");
$bankcard = mysql_result($query, $i, "bankcard");
$amex = mysql_result($query, $i, "amex");
$directbill = mysql_result($query, $i, "directbill");
$total2 = mysql_result($query, $i, "total2");

echo "<TR CLASS=\"MYTABLE\">";
echo "<TD CLASS=\"MYTABLE\">" . $id . "</TD>";
echo "<TD CLASS=\"MYTABLE\">" . $date . "</TD>";
echo "<TD CLASS=\"MYTABLE\">" . $rooms . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $tax . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $misc . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $total1 . "</TD>";
echo "<TD CLASS=\"MYTABLE\">   </TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $cash . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $bankcard . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $amex . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $directbill . "</TD>";
echo "<TD CLASS=\"MYTABLE\">$" . $total2 . "</TD>";
echo "</TR>";
$i++;
}
mysql_close();

echo '</TBODY>';

$mailbody = ob_get_contents();
ob_end_flush();   // end here

// HTML HEADERS
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: somewhere <[email protected]>' . "\r\n";

mail("[email protected]","subject",$mailbody,$headers);
?>