|
|
Posted by My Pet Programmer on 12/24/07 15:36
paul814@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!
Navigation:
[Reply to this message]
|