Hi!
I’m new here and pretty much an amateur with PHP.
For my website, I have a PHP CRON script which when run should send an e-mail to all users on my site whose profile will expire in 2 days time, to remind them to renew. This is the script:
[php] 1 <?
2 mysql_connect(“localhost”,“myco_mycoabc”,“test@123”);
3 mysql_select_db(“myco_mycoabc”);
4
5 $sql=“select * from tbl_signup_user WHERE DATEDIFF(endDate, now()) = 2 “;
6 $rs=mysql_query($sql);
7 while($row=mysql_fetch_array($rs))
8 {
9
10 $userEmail=$row[‘email’];
11 $userName=$row[‘user_name’];
12 $firstName=$row[‘first_name’];
13 $end_Date=date(“l F d, Y”,strtotime($row[‘endDate’]));
14 $from="[email protected]”;
15 $message = “This is a multi-part message in MIME format.\n\n” .
16 “–{$mime_boundary}\n” .
17 “Content-Type: text/html; charset=“iso-8859-1”\n” .
18 “Content-Transfer-Encoding: 7bit\n\n” .
19 $message . “\n\n”;
20 $msg .=“Hi “.$firstName.” \n\n As you may be aware your “.$userName.” profile on www.myco.co.uk is due to expire on “.$end_Date.”.” . “\n\n”;
21 $msg .=“If you wish to continue being a member of our directory, please log into your account, select “Renew my Profile” and choose your payment option.” . “\n\n”;
22 $msg .=“We are now one of the best directories in the UK, giving excellent value for money:” . “\n\n”;
23 $msg .=”+ Good quality photo gallery" . “\n”;
24 $msg .="+ Easy to edit your profile" . “\n”;
25 $msg .="+ All major debit & credit cards accepted" . “\n\n”;
26 $msg .=“If you have any questions please let us know.” . “\n\n”;
27 $msg .=“All the best” . “\n\n”;
28
29 $msg .=“My Company Support” . “\n”;
30 $msg .=“www.myco.co.uk” . “\n”;
31
32
33 ;
34 $headers = “From:” . $from;
35 mail($userEmail, “My Company subscription”,$msg,$headers);
36 }
37 ?>
[/php]
However, the script is sending the firstname and username of all selected members in the same e-mail in some of the e-mails! i.e. rather than each member who expires in 2 days just getting the e-mail personalised with their firstname and username, at the bottom it then appends it with the same e-mail with the firstname and username of the other members expiring in 2 days time!
Please could someone tell me where I’m going wrong and how to fix it?
Many thanks!
Steve