[RESOLVED] email recipients from recordset issue

[vinny199]

Hi,

I am stuck trying to do the following:

email all users from my recordset that match the following criteria:
membership will expire within 5 days

I have got my SQL statment to work (although there is probably a better way to word it, it works)

$query_rsusers1 = "SELECT * FROM users WHERE (TO_DAYS(users.endaddate) <= TO_DAYS(NOW())+5) AND (TO_DAYS(users.endaddate) > TO_DAYS(NOW()))";

This gives me the list of all the users in my "users" table whose membership will exprire between tomorrow and 5 days time.

I can therfore retrieve their email :

$row_rsusers1['email'];

So I'm trying to send them an expiring subscription message as follow:

 $email_text = $_REQUEST['email_text'] ;
  $address = $row_rsusers1['email'];

  mail( "$address", "membership expiring notice",
    "
$email_text", "From: [e-mail]" );
  header( "Location: http://www.mysite.com/admin/email_sent.php" );

Of course, this does not work as I only send to one recipient and I have no idea how to syntax it so it sends to all recipeints from the recordeset.

Many thanks for your help,

Vinny

[thorpe]

You need to loop through your results. Something like...

<?php

  // connect to db
  if ($result = mysql_query("SELECT * FROM users WHERE (TO_DAYS(users.endaddate) <= TO_DAYS(NOW())+5) AND (TO_DAYS(users.endaddate) > TO_DAYS(NOW()))") {
    while ($row = mysql_fetch_assoc($result)) {
      $email = $row['email'];
      // send email
    }
  }

?>

[vinny199]

Thanks but no luck up to now.

It posts to the first record it finds in the table only.

Although my recordset returns 3 records.
the email only goes to the first one)

Here is what I have:

mysql_select_db($database_to_octo, $to_octo);
$query_rsusers1 = "SELECT * FROM users WHERE (TO_DAYS(users.endaddate) <= TO_DAYS(NOW())+5) AND (TO_DAYS(users.endaddate) > TO_DAYS(NOW()))";


   if ($result = mysql_query ($query_rsusers1) )

while ($row = mysql_fetch_assoc($result))     { 
  $email = $row['email']; }
  // send email 
{   mail( "$email", "membership auto renewal notice",
"
test", "From: [e-mail]" );
  } 

mysql_query($query_rsusers1) or die(mysql_error());

any idea where it's going wrong?

thanks,
V.

[duckduckgoose]

You closed your while loop before you sent the mail:

mysql_select_db($database_to_octo, $to_octo); 
$query_rsusers1 = "SELECT * FROM users WHERE (TO_DAYS(users.endaddate) <= TO_DAYS(NOW())+5) AND (TO_DAYS(users.endaddate) > TO_DAYS(NOW()))"; 


   if ($result = mysql_query ($query_rsusers1) )  {

while ($row = mysql_fetch_assoc($result))     { 
  $email = $row['email'];  
  // send email 
mail( "$email", "membership auto renewal notice",  "test", "From: [e-mail]" ); 
  } 

} else {
mysql_query($query_rsusers1) or die(mysql_error()); 
}

[vinny199]

AH!

OK.

Thanks a lot