|
|
Posted by paul814 on 12/24/07 15:18
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
[Back to original message]
|