|
|
Posted by J.O. Aho on 04/26/06 07:06
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
Navigation:
[Reply to this message]
|