I have a mailing list script that functions fine in terms of sending the emails to all address in the database, but it includes a single name with all the emails.

The code is below. I have no clue what's going on. Anyone have any ideas? Thanks in advance.

PHP Code:

$query_review = mysql_query("SELECT * FROM pmenu_review_list");           
        while($mailstat_re = mysql_fetch_array($query_review)){
            $review_name = $mailstat_re[name];
            $review_email = $mailstat_re[email];
            
            $message_review = "";
        
        mail($review_email,$subject,$message_review,$headers);
        } 


First of all if you had 10,000 users then you would have to (in the method above) send 10,000 seperate emails and this (going on the method above) would meen 10,000 calls to sendmail (if this was the program).

Thats drastic on the server.

Instead you should bcc your list and send approx 100 at a time (some servers don't even allow this many). Also you can split your mailing list down into days. So everyone who has a last name starting with A to H gets amailed on day one H to M day 2 etc.

Of course people do things differently but mostly for the same reasons.

As for your query

$mailstat_re[name] should be called as $mailstat_re['name'] this then would return Joe Bloggs instead of name.

Ibbo

Yeah, I'm realy behind on updating it since I know the current method is not ideal and very slow/taxing.

But the array isn't actually printing "name"; it's including a name from a table row different from the row of the email. In other words, say this is the DB table:

------------------------------------
name | email
---------------------------------
greg | greg@com.com
-----------------------------------
joe | joe@com.com
-----------------------------------
bill | bill@com.com
-----------------------------------

What's happening is Joe's name is ending up in the emails sent to greg, joe and bill.

Hmmmm

Thats very bizarre, and quite frankly with the statement you have it should not do that at all. I have a similar problem on one of my sites where the previous listings URL will appear in the following ones. Very anoying and as of yet i cant fathom whats wrong.

Good luck with it

Ibbo

Nothing appears to be wrong with your code.

Have you verified the data in your database? The names are different in the database, right?

- bob

Yeah, data is all solid in the db.