Thank you!! This appears to have solved it... I didn't even think of using the "$message" variable instead of the "print()"... Sheesh... I still have LOTS to learn!! Chase "Micah Stevens" <micah@raincross-tech.com> wrote in message 1038878012.23696.129.camel@tyrell">news:1038878012.23696.129.camel@tyrell... > Remember, the print() function sends stuff to the browser. If you wish > to make the code output to the $message variable, you must use > additional assignment statements. > > I made some quick changes to the code below, try that: > > <? > $server = ""; > $user = ""; > $pass = ""; > $db = ""; > $table = ""; > ?> > > <? > $to = "CKnott <cknott@micsystems.com>" . ", " ; > $to .= "Chase <chase@ck2000.biz>"; > > $subject = "Price File Access History"; > > $message = ' > <html> > <head><title>Price File Access</title></head> > > <body> > <table border="1" align="center"> > <tr> > <td> > <div align="center"><b><i>Date / Time</i></b></div> > </td> > <td> > <div align="center"><i><b>Logged IP Address</b></i></div> > </td> > <td> > <div align="center"><i><b>Logged Username</b></i></div> > </td> > </tr> > '; > > $link = mysql_connect("$server", "$user", "$pass"); > mysql_select_db("$db", $link); > > $result = mysql_query("SELECT * FROM $table ORDER BY 'view_date' > DESC",$link); > $num_rows = mysql_num_rows($result); > > if($num_rows) { > // print("<p><table border=1 align=center>"); > while($row = mysql_fetch_row($result)) > > { > > $message .= "<tr>"; > $message .= "<td>$row[0]</td>"; > $message .= "<td>$row[1]</td>"; > $message .= "<td>$row[2]</td>"; > $message .= "</tr>"; > > > } > $message .= "</table></p>"; > } else { > $message .= "No Files To Show!!"; > > } > $message .= "</body> > </html> > "; > > $headers = "MIME-Version: 1.0\r\n"; > $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; > > $headers .= "From: MIC Price File Monitor <cknott@micsystems.com>\r\n"; > > mail($to, $subject, $message, $headers); > > ?> > > > > On Mon, 2002-12-02 at 16:30, Chase wrote: > > There is a single quote and semicolon on the line under </html> that I > > thought would be defining the end of the assignment. > > Should I have used double quotes instead of single? > > > > Chase > > > > > > "Micah Stevens" <micah@raincross-tech.com> wrote in message > > 1038870535.23725.123.camel@tyrell">news:1038870535.23725.123.camel@tyrell... > > > There aren't any closing quotes on your $message variable or semicolon > > > to tell the parser that you're done with the assignment statement. > > > > > > -Micah > > > > > > > > > > > > > > > > > > On Mon, 2002-12-02 at 15:05, Chase wrote: > > > > When trying to execute the following script to send the contents of a > > table > > > > via "mail()" I am getting this error... > > > > > > > > Parse error: parse error, unexpected T_STRING in FILENAME.PHP on line 36 > > > > > > > > The portion of this code inside the HTML tags works great for displaying > > the > > > > table on the screen, but when I include it in the larger script for > > sending > > > > a mail message, I get this error. > > > > > > > > I am sure that it is something simple that I have been too stupid to > > catch, > > > > but any help would be great! > > > > > > > > Chase > > > > > > > > > > > > Code Follows ---> > > > > > > > > <? > > > > $server = ""; > > > > $user = ""; > > > > $pass = ""; > > > > $db = ""; > > > > $table = ""; > > > > ?> > > > > > > > > <? > > > > $to = "CKnott <cknott@micsystems.com>" . ", " ; > > > > $to .= "Chase <chase@ck2000.biz>"; > > > > > > > > $subject = "Price File Access History"; > > > > > > > > $message = ' > > > > <html> > > > > <head><title>Price File Access</title></head> > > > > > > > > <body> > > > > <table border="1" align="center"> > > > > <tr> > > > > <td> > > > > <div align="center"><b><i>Date / Time</i></b></div> > > > > </td> > > > > <td> > > > > <div align="center"><i><b>Logged IP Address</b></i></div> > > > > </td> > > > > <td> > > > > <div align="center"><i><b>Logged Username</b></i></div> > > > > </td> > > > > </tr> > > > > > > > > $link = mysql_connect("$server", "$user", "$pass"); > > > > mysql_select_db("$db", $link); > > > > > > > > $result = mysql_query("SELECT * FROM $table ORDER BY 'view_date' > > > > DESC",$link); > > > > $num_rows = mysql_num_rows($result); > > > > > > > > if($num_rows) { > > > > // print("<p><table border=1 align=center>"); > > > > while($row = mysql_fetch_row($result)) > > > > > > > > { > > > > > > > > print("<tr>"); > > > > print("<td>$row[0]</td>"); > > > > print("<td>$row[1]</td>"); > > > > print("<td>$row[2]</td>"); > > > > print("</tr>"); > > > > > > > > > > > > } > > > > print("</table></p>"); > > > > } else { > > > > print("No Files To Show!!"); > > > > > > > > } > > > > > > > > </body> > > > > </html> > > > > '; > > > > > > > > $headers = "MIME-Version: 1.0\r\n"; > > > > $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; > > > > > > > > $headers .= "From: MIC Price File Monitor <cknott@micsystems.com>\r\n"; > > > > > > > > mail($to, $subject, $message, $headers); > > > > > > > > ?> > > > > > > > -- > > > Raincross Technologies > > > Development and Consulting Services > > > http://www.raincross-tech.com > > > > > > > -- > Raincross Technologies > Development and Consulting Services > http://www.raincross-tech.com > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
