|
|
Posted by paul814 on 12/24/07 15:33
On Dec 24, 10:22 am, My Pet Programmer <anth...@mypetprogrammer.com>
wrote:
> paul...@excite.com said:
>
>
>
> > On Dec 24, 9:32 am, My Pet Programmer <anth...@mypetprogrammer.com>
> > wrote:
> >> paul...@excite.com said:
>
> >>> On Dec 21, 1:41 pm, Iván Sánchez Ortega <ivansanchez-...@rroba-
> >>> escomposlinux.-.punto.-.org> wrote:
> >>>> paul...@excite.com wrote:
> >>>>> On Dec 21, 1:05 pm, Iván Sánchez Ortega <ivansanchez-...@rroba-
> >>>>> escomposlinux.-.punto.-.org> wrote:
> >>>>>> paul...@excite.com wrote:
> >>>>>>> while ($row = mysql_fetch_array($result)) { // puts the values into
> >>>>>>> $row
> >>>>>>> print $row->editorialdate;
> >>>>>>> print $row->editorialname;
> >>>>>>> print $row->editorialcomments;
> >>>>>>> }
> >>>>>> [...]
> >>>>>>> $txt = "$row[0] \n\r\n\rPLEASE DO NOT REPLY TO THIS EMAIL, THIS IS NOT
> >>>>>>> A VALID EMAIL ADDRESS";
> >>>>>>> $headers = "From: Daily_Prod._Rep...@company.com";
> >>>>>>> mail($to,$subject,$txt,$headers); # <--- sends the email
> >>>>>> [...]
> >>>>>>> all I get is a blank email with no data in it from my database.
> >>>>>>> Anyone have any ideas?
> >>>>>> I'm not very sure *grin*, but maybe it's because you're printing the data
> >>>>>> instead of storing it in the variable that will be fed to mail() ....
> >>>>> How would I store it?
> >>>> Geez.
> >>>> $txt = '';
> >>>> while ($row = mysql_fetch_array($result)) {
> >>>> $txt .= $row->editorialdate;
> >>>> $txt .= $row->editorialname;
> >>>> $txt .= $row->editorialcomments;}
> >>>> (snip)
> >>>> mail($to,$subject,$txt,$headers);
> >>>> --
> >>>> ----------------------------------
> >>>> Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org-
> >>>> Proudly running Debian Linux with 2.6.22-3-amd64 kernel, KDE 3.5.8, and PHP
> >>>> 5.2.4-2 generating this signature.
> >>>> Uptime: 19:39:46 up 29 days, 5:55, 4 users, load average: 0.75, 1.34,
> >>>> 1.05
> >>> I still can not get this to work...I've added your changes and still
> >>> get a blank email.
> >>> Generating and emailing report for:
> >>> <?php
> >>> $today = date("M j, Y,");
> >>> echo $today;
> >>> $host="localhost";
> >>> $user="root";
> >>> $pass="";
> >>> $db="productiondb";
> >>> $con = mysql_connect($host, $user, $pass);
> >>> $txt = '';
> >>> if (!$con)
> >>> {
> >>> die('Unable to connect: ' . mysql_error());
> >>> }
> >>> mysql_select_db($db, $con) or die('Unable to connect: ' .
> >>> mysql_error());
> >>> $sql = "SELECT * FROM editorial WHERE editorialdate LIKE '$today%' ";
> >>> $result = mysql_query($sql,$con); // actually runs the query
> >>> if (mysql_num_rows($result)) { // if there are results
> >>> while ($row = mysql_fetch_array($result)) { // puts the values into
> >>> $row
> >>> $txt .= $row->editorialdate;
> >>> $txt .= $row->editorialname;
> >>> $txt .= $row->editorialcomments;
> >>> }
> >>> }
> >>> //this part sends email
> >>> ini_set("SMTP", "texchange.company.com");
> >>> ini_set("smtp_port", "25");
> >>> $to = "p...@company.com";
> >>> $subject = "Production report";
> >>> $txt = "$row \n\r\n\rPLEASE DO NOT REPLY TO THIS EMAIL, THIS IS NOT A
> >>> VALID EMAIL ADDRESS";
> >>> $headers = "From: Daily_Prod._Rep...@company.com";
> >>> mail($to,$subject,$txt,$headers); # <--- sends the email
> >>> mysql_close($con); //closes the connection to the DB
> >>> ?>
> >>> Any ideas? thanks.
> >> I might be wrong, but don't the headers require a newline at the end?
> >> That might have something to do with it, but I don't see anything else.
>
> >> ~A!
>
> > Well I tried that and that did not change anything
>
> What do you get if you print $txt and exit? Is that populated ok?
If I echo $txt on the page....I get:
PLEASE DO NOT REPLY TO THIS EMAIL, THIS IS NOT A VALID EMAIL ADDRESS
Navigation:
[Reply to this message]
|