[Resolved] [Resolved] [Resolved] [Resolved] [Resolved] [Resolved] [Resolved] [Resolved] Hello wise g

Marcusanthonius

I got a script which has to send people personized mail.
And although I am almost finished it (i hope) I got the problem with the while loop.
Yes, with this script everyone in the MYSQL database gets mail, but number two in the list got except for their variabels also the var. of other persons, like..

Dear Sir Johnson,
new on our site is....

And the next person gets:
Dear Sir Johnson, Dear madame Jameson,
new on our site is....

How do I have to change this while loop?
every help is appreciated.

Thanks

<?
//connect
@ $db = mysql_connect('localhost', 'user', 'password');
if (!db)
{
echo 'Error: Kon geen connectie met de database maken. Probeert u het later nog eens.';
exit;
}
mysql_select_db("mailing");
$result = mysql_query ("select gender, lastname, mailadres from unieke_mailinglist");
if (!$result) {
die('Could not query:' . mysql_error());
}

while ($row = mysql_fetch_array($result))
{
$potklant_id = $row['potklant_id'];
$geslacht = $row['gender'];
$achternaam = $row['lastname'];
$mailadres = $row['mailadres'];
if ($gender == "m")
{
$geslacht = "sir";
}
else
{
$gender = "madame";
}

$STRcontent = "Dear".$gender." ".$achternaam." 
new on our site is.... 
And we are pleased to...";

$body .= " <html><head><title>Bordeaux primeurs 2003</title></head> \n";
$body .= " <body bgcolor=\"#FFFFCC\" text=\"#0000FF\"> \n";
$body .= $STRcontent;
$body .= " </body>";
$body .= " </html>";

$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
if ($STRinviter == "") {
$STRinviter = "Van Mij";
}
if ($STRfrom == "") {
$STRfrom = "ikke@hccnet.nl";
}
$headers .= "From: ".$STRinviter." <".$STRfrom.">\r\n";

$STRlink = " click the following link for the details: <a target='_blank' href='http://www.site.nl/page.html'>to page</a> \n";
mail($mailadres, "Nieuwsbrief", $body.$STRlink, $headers);
}

if(!$result)
{
echo "Update not sent ", mysql_error();
exit;
}
if($result)
{
mysql_close($db);?>
<?
print "<html><head><title>Bordeaux Primeurs 2003</title><link REL='STYLESHEET' HREF='css/sfx.css' TYPE='text/css'></head><body onLoad='setTimeout(window.close, 1000)'>";
print "Your Update has been sent to everyone";
print "</body></html>";
}
?>😃

mtimdog

for clarity

<? 
//connect 
@ $db = mysql_connect('localhost', 'user', 'password'); 
if (!db) 
{ 
echo 'Error: Kon geen connectie met de database maken. Probeert u het later nog eens.'; 
exit; 
} 
mysql_select_db("mailing"); 
$result = mysql_query ("select gender, lastname, mailadres from unieke_mailinglist"); 
if (!$result) { 
die('Could not query:' . mysql_error()); 
} 

while ($row = mysql_fetch_array($result)) 
{ 
$potklant_id = $row['potklant_id']; 
$geslacht = $row['gender']; 
$achternaam = $row['lastname']; 
$mailadres = $row['mailadres']; 
if ($gender == "m") 
{ 
$geslacht = "sir"; 
} 
else 
{ 
$gender = "madame"; 
} 

$STRcontent = "Dear".$gender." ".$achternaam."<br/> 
new on our site is.... <br/> 
And we are pleased to..."; 


$body .= " <html><head><title>Bordeaux primeurs 2003</title></head> \n"; 
$body .= " <body bgcolor=\"#FFFFCC\" text=\"#0000FF\"><font face='verdana' size='2'> \n"; 
$body .= $STRcontent; 
$body .= " </body>"; 
$body .= " </html>"; 

$headers = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
if ($STRinviter == "") { 
$STRinviter = "Van Mij"; 
} 
if ($STRfrom == "") { 
$STRfrom = "ikke@hccnet.nl"; 
} 
$headers .= "From: ".$STRinviter." <".$STRfrom.">\r\n"; 





$STRlink = " <br>click the following link for the details:<br><a target='_blank' href='http://www.site.nl/page.html'>to page</a> \n"; 
mail($mailadres, "Nieuwsbrief", $body.$STRlink, $headers); 
} 

if(!$result) 
{ 
echo "<p align=center><b>Update not sent</b> ", mysql_error(); 
exit; 
} 
if($result) 
{ 
mysql_close($db);?> 
<? 
print "<html><head><title>Bordeaux Primeurs 2003</title><link REL='STYLESHEET' HREF='css/sfx.css' TYPE='text/css'></head><body onLoad='setTimeout(window.close, 1000)'>"; 
print "<p align=center>Your Update has been sent to everyone</p>"; 
print "</body></html>"; 
} 
?>

mtimdog

It could possibly be that the first

$body .=
should be
$body =

Marcusanthonius

thanks for replying.. but that doesn't solve my problem. (although i will change that.)
You got comments about the mysql_fetch_array which I have used?
How can I adress the interested people by personalized email?

Thanks in advance....

LordShryku

You should move this to the coding forum. This forum is for finished code, not help.

Weedpacket

Try asking in an appropriate forum. If you don't know why this forum is not appropriate, see the forum rules and guidelines.

mtimdog

Also, you seem to be switching between $geslacht and $gender, and how are you getting the 'potklant_id' without selecting it in the query?

Marcusanthonius

Many Thanks mtimdog,

your first answer was very right.
At first i didn't even try it.. I thougt it was to simple.
Well that makes me a rookie...
But I have putted lots off time in my script, just to get it work.
Every evening and night after working ours.
Of course I understand that most people do this aswell...
and yess, it becomes very addictive. ( Long live programming)

Anyway... it is a little inconvienent to get aswers like:
You post in the wrong forum etc...
Well, if you guys really like to know;
in the rules stands also you may not post the same thread in different forums.

And you know what?
I did that too.
Because I really needed help.
And now and in the future, when i become better, i will give normal help to others.

If you aren't willing to help, just don't.
Why taking time for people with annoying answers?

Thanks again, mtimdog.
(I am sorry I questioned your first answer)
And for the others..
use my script. it is fast and easy to use for starters like me!

LordShryku

Originally posted by Marcusanthonius
Anyway... it is a little inconvienent to get aswers like:
You post in the wrong forum etc...

The rules are made for you convenience. This would have been looked at and answered much earlier if you had posted it in the right forum. Being a rookie doesn't give you the right to be ignorant to the rules, and had you taken two minutes to read them, you would have know this already.

mtimdog

Perhaps this is another thread, but on the same topic how does everyone browse for threads to answer??

I look at the new posts (disregarding of what category they are in), and choose a title that I may be able to solve. For me, it doesn't matter what category it was posted in, I still solved it at my earliest convenience (when I arrived at work). Maybe this should be a poll? Oh well, gotta get dressed to go to my second job (landscaper).