mail() and mysql

Hi everyone

I am trying to send a e-mail using the mail() function.
Now i try to send more than one data from mysql database so i must use
example

$results=mysql_num_rows($result_query)
for(i=0; $i < $results; i++)
{
$row=mysql_fetch_array($result_query);
echo $row['name'];
echo " ";
echo $row['blabla'];
}

if i use mail() function one parametar must be variable example $text

I cant put more than one parameter in mail function or if i use $text
variable in string i cant put for()..etc

example

$text ="This is costumers names".
for(i=0; $i < $results; i++)
{
$row=mysql_fetch_array($result_query);
echo $row['name'];
echo " ";
echo $row['blabla'];
}." ..etc";

This is no working solution

mail(some@some.so, help, $text);

I am new in php programing and i have no idea how to do this.
Thanks Ivan

Re: mail() and mysql

Bandul wrote:
> Hi everyone
>
> I am trying to send a e-mail using the mail() function.
> Now i try to send more than one data from mysql database so i must use
> example
>
> $results=mysql_num_rows($result_query)
> for(i=0; $i < $results; i++)
> {
> $row=mysql_fetch_array($result_query);
> echo $row['name'];
> echo " ";
> echo $row['blabla'];
> }
>
> if i use mail() function one parametar must be variable example $text
>
> I cant put more than one parameter in mail function or if i use $text
> variable in string i cant put for()..etc
>
> example
>
> $text ="This is costumers names".
> for(i=0; $i < $results; i++)
> {
> $row=mysql_fetch_array($result_query);
> echo $row['name'];
> echo " ";
> echo $row['blabla'];
> }." ..etc";

This is the same and less code, if you want to limit number of fetches, use
LIMIT in your SQL-query.

$text ="This is costumers names".
while($row=mysql_fetch_array($result_query)) {
echo $row['name'];
echo " ";
echo $row['blabla'];
}

> This is no working solution
>
> mail(some@some.so, help, $text);

If you want to store something in a variable, then don't use echo, as it will
always go to stdout (in this case the webserver).

$text ="This is costumers names".
while($row=mysql_fetch_array($result_query)) {
$text .= $row['name'];
$text .= " ";
$text .= $row['blabla'];
}

mail(some@example.net, "Customer info", $text,'From: webmaster@example.com');

the '.=' is used to append text to a variable, which makes it easy to build
string of text as an auto generated list of data that will be sent with mail().



//Aho

Re: mail() and mysql

Thanks

"J.O. Aho" wrote in message
news:4b89tfF106ukfU1@individual.net...
> Bandul wrote:
>> Hi everyone
>>
>> I am trying to send a e-mail using the mail() function.
>> Now i try to send more than one data from mysql database so i must use
>> example
>>
>> $results=mysql_num_rows($result_query)
>> for(i=0; $i < $results; i++)
>> {
>> $row=mysql_fetch_array($result_query);
>> echo $row['name'];
>> echo " ";
>> echo $row['blabla'];
>> }
>>
>> if i use mail() function one parametar must be variable example $text
>>
>> I cant put more than one parameter in mail function or if i use $text
>> variable in string i cant put for()..etc
>>
>> example
>>
>> $text ="This is costumers names".
>> for(i=0; $i < $results; i++)
>> {
>> $row=mysql_fetch_array($result_query);
>> echo $row['name'];
>> echo " ";
>> echo $row['blabla'];
>> }." ..etc";
>
> This is the same and less code, if you want to limit number of fetches,
> use LIMIT in your SQL-query.
>
> $text ="This is costumers names".
> while($row=mysql_fetch_array($result_query)) {
> echo $row['name'];
> echo " ";
> echo $row['blabla'];
> }
>
>> This is no working solution
>>
>> mail(some@some.so, help, $text);
>
> If you want to store something in a variable, then don't use echo, as it
> will always go to stdout (in this case the webserver).
>
> $text ="This is costumers names".
> while($row=mysql_fetch_array($result_query)) {
> $text .= $row['name'];
> $text .= " ";
> $text .= $row['blabla'];
> }
>
> mail(some@example.net, "Customer info", $text,'From:
> webmaster@example.com');
>
> the '.=' is used to append text to a variable, which makes it easy to
> build string of text as an auto generated list of data that will be sent
> with mail().
>
>
>
> //Aho