select * and email them?

[Jonnyfive]

Anyone know of any way to perform a query on my database and return all email addresses(which is a field) of users that have not completed a certain task by a certain date? Then send all of the email addresses an email reminder?

There is going to be a button that i'll push on every tuesday to do the query but how would i automate the emailing process to email all those that need to get the reminder to do their survey by wednesday? Make any sense? any ideas? Thanks

[planetsim]

well you may wanna have a feild which says if they've done whats needed.

So when you wanna send it you'd use a simple while loop

[orangehairedboy]

I would make a table like user INT, task TEXT, duedate, DATE, status VARCHAR(20).

Then I would pull:

select * from users where duedate<now() and status='Pending';

while ( $a_row = mysql_fetch_array( $query ) )
 {
 $body = "Hello $a_row[user]!\nYou have a pending task:\n\n$a_row[task]\n\nPlease finishing it or suffer the consequences. It was due $a_row[date].\n";
 /* code to send email */
 }

Obviously that won't work if you copy and paste it, but you should get the gist.

OHB

[keyurjbhatt]

you set address of only first user and
other with cc field and then send them

for cc field you have to make header like
$mail_cc="[e-mail]";
$mail_headers = "From: $mail_from\r\nReply-to:
$mail_reply_to\r\nCc:$mail_cc\r\nBcc: $mail_bcc";

and add that header in mail commad like
mail($mail_to,$mail_subject,$mail_body,$mail_he
aders)

i have not try but i think so

[Jonnyfive]

Thanks a million, that's not exactly how i have it set up but it's close.

[id10t]

I'd think sending the individual users an individual mail would be better. Otherwise, use BCC instead of CC - it will keep the headers from being too long and truncating. Also keeps everyone from seeing who else is getting fired on Thursday.