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