Re: Re: Email DataBase Results

$headers .= "Content-Type: text/html; charset=iso-8859-1"; Quoting Robert Pruitt <rpruitt@Mid-tn.com>: > Thank-you Salah. I apologize for having to amend my question. It was > poorly asked. > > Here's what I really want. > > mail("joecool@example.com", > "My Subject", > > "<table><tr><td>Head1</td><td>Head2</td><td>Head3</td></tr> > > > <tr><td>$variable1</td><td>$variable2</td><td>$variable3</td></tr></table>"); > > I'm a bit confused. > > Peace Upon You > > Salah Faya wrote: > > > Collect all data rows in one variable first, Try this: > > > > $query = "select * from table"; > > $result = mysql_db_query("$dbName", $query); > > $msg = ''; > > while ($r = mysql_fetch_array($result)) { > > $variable1 = $r["variable1"]; > > $variable2 = $r["variable2"]; > > $variable3 = $r["variable3"]; > > $msg.="$variable1 - $variable2 - $variable3 \n"; > > } > > > > mail("joecool@example.com", "My Subject", $msg); > > > > ----- Original Message ----- > > From: "Robert Pruitt" <rpruitt@Mid-tn.com> > > To: <php-general@lists.php.net> > > Sent: Monday, April 21, 2003 10:59 PM > > Subject: [PHP] Email DataBase Results > > > > > $query = "select * from table"; > > > $result = mysql_db_query("$dbName", $query); > > > while ($r = mysql_fetch_array($result)) { > > > $variable1 = $r["variable1"]; > > > $variable2 = $r["variable2"]; > > > $variable3 = $r["variable3"]; > > > } > > > > > > mail("joecool@example.com", "My Subject", "$variable1 - > > > $variable2 - > > > $variable3"); > > > > > > > > > What is the best way to include the results of this query into the > > > mail() function? > > > > > > The above trial will not give full results. > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >