Re: Re: Email DataBase Results

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.