Re: Re: Email DataBase Results

When denseness strikes, it's best to walk away from the thing, and come back later. Salah's example worked beautifully, when I include whatever html I need in the $msg variable, i.e., $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.="<tr><td>$variable1</td><td>$variable2</td><td>$variable3</td></tr>"; } mail("joecool@example.com", "My Subject", $msg); 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.