Question about mail()

wendyz · #1 24-Feb-2009, 17:12

I store several data in database with the same tracking number, now I get those data from database and send email to someone. the problem is how can I store those data in to $message line by line. example:
in database I have

Code:

key           department             subject
1               usergroup               testing1
1               usergroup               testing2
1               other                     testing3

then after I select data by $mysql_query($sql)
I should get all data with key=1, and save into $message, then I can use
mail($to,$subject, $message) send email, I will get all information in the mail.

But I use $mysql_fetch_array($sql), only save last record into $message, anyone can help me?

wendyz · #2 24-Feb-2009, 18:37

I fix this problem

admin · #3 24-Feb-2009, 23:47

Assuming the data was queried this way:

PHP Code:


<?php
    // stores the (email) message
    $message = null;
    // get the data off the database table
    $sql =
        "SELECT * 
        FROM `my_table`
        WHERE `key`=1";

    if( $resource=mysql_unbuffered_query($sql, $conn) )
    {
        while( $row=mysql_fetch_assoc($resource) )
        {
            $message .= implode( "\t", $row ). "\n";
        }
    }

    if( $message )
    {
        // send an email
        mail( "example@example.com", "My Subject", $message );
    }

?>

That would do the trick.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Please, This is Difficult question try for me!	bcompt143	C++ Forum	4	24-Aug-2008 09:14
Reliable Hosting $2-$8/month: PHP, MySQL, FrontPage, CGI, SSH, FTP, POP3, Web Mail	fcolor	Web Hosting Advertisements & Offers	0	04-Nov-2003 06:03
Guestbook error	BobbyDouglas	Web Design Forum	1	16-Oct-2003 22:17
600MB Space, 20GB Banwidth, PHP, MySQL, CGI, SSH, FrontPage, FTP, POP3, Web Mail	fcolor	Web Hosting Advertisements & Offers	0	08-Aug-2003 10:11
Yahoo! Mail (POP Access)	nniehoff	Open Discussion Forum	1	17-Jan-2003 06:55

Question about mail()

Re: Question about mail()

Re: Question about mail()