Mail List

[Anon]

Basically what im trying to do is grab data from a MySQL DB. I will be grabbing the data from mulitple rows and then I want to mail it to a address.

Now what i have so far is grabbing the data from the rows. That data i want to be in the body of the message. How would i go about doing this?

here is my query:

$query = mysql_query("SELECT FROM $mysql_table WHERE date >= $start_time AND date <= $end_time") or die ("Error");
while ($r = mysql_fetch_array($query))
{
/
If i put the mail function here it will mail each time for each row. All i want is to mail once for all the rows. All the rows data will be inserted into the message.
*/
}

Any ideas?

[Anon]

try this
$r=mysql_fetch_array($query);
for ($i=0;$i<count($r);$i++)
$temp.= r[$i]."\n";
/* send the $temp variable

the \n is a linefeed..

[Anon]

This is only mailing me the last row of the table. Code im using below. Any other ideas? Or did i do something wrong down there?

$query = mysql_query("SELECT * FROM $mysql_table WHERE date >= $start_time AND date <= $end_time") or die ("Error");
$r = mysql_fetch_array($query);
for ($i=0; $i<count($r); $i++)
{
$temp .= $r[$i]."\n";
}

mail("[e-mail]","Error Report","$temp");

[Anon]

sorry, , the mysql_fetch_array command fetches just 1 row at a time.. (field names become array values), try this..
while ($r=mysql_fetch_array($query))
$temp .= $r("field name u want to send");

if u want to send more field names, try something like this

while...
$temp .= $r['field1'];
$temp .= $r['field2'];
i think this should work.. but im not certain.. i don't work with mysql..

[Anon]

You are the man... Thank you.

I never really understood what .= was for. i do now. Thank You. Works perfect