|
|
Posted by paul814 on 12/24/07 15:53
On Dec 24, 10:36 am, My Pet Programmer <anth...@mypetprogrammer.com>
wrote:
> paul...@excite.com said:
>
>
>
> > 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
>
> Just out of curiosity, what is the column def on the date field in the
> table? The usual format for date queries from MySQL is Y-m-d for DATE
> and Y-m-d g:i:s for date time. It looks like $txt is not getting
> populated at all, and I'm thinking it's maybe not getting anything from
> the recordset.
>
> ~A!
Well the editorialdate is stored as a VARCHAR and I have to do it that
way because of some other things that I am doing...I cant store it as
DATE/TIME. But it is populated as:
Dec 24, 2007, 8:37 am
for example.
Navigation:
[Reply to this message]
|