Home > Archive > PHP SQL > April 2006 > Re: mail() and mysql
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: mail() and mysql
|
|
| J.O. Aho 2006-04-26, 3:59 am |
| 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_que
ry)) {
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_que
ry)) {
$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
| |
| Bandul 2006-04-26, 3:59 am |
| Thanks
"J.O. Aho" <user@example.net> wrote in message
news:4b89tfF106ukfU1@individual.net...
> Bandul wrote:
>
> 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_que
ry)) {
> echo $row['name'];
> echo " ";
> echo $row['blabla'];
> }
>
>
> 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_que
ry)) {
> $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
|
|
|
|
|