|
|
Posted by Bandul on 04/26/06 12:07
Thanks
"J.O. Aho" <user@example.net> 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
Navigation:
[Reply to this message]
|