- Impact
- 0
Alright...well, I'm very new to PHP and this is my first little script I'm doing for work. I have EVERYTHING working....
Here is the result table....
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.
- 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....
Code:
<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.
