Hello,
I do hope some kind soul can help me with what I thought was not going
to be difficult, but for this newbie it's a bit harder than I thought.
Here's what I'm trying to do.....
I can select from my database the records that I need, but I need to
insert them somewhere down the page so that I can process them. Here's
my select statement......
SELECT email,equipment,username,status FROM table WHERE status = 'J'
That's all fine and dandy and php admin returns the correct info.
What I want to do is pass the returned information into 4 variables
that I can use to cal into a php() mail function.
I need to end up with....
$email
$equipment
$username
$status
.......so that I can use the variables as below.....
$to = "$email";
$headers .= "$username";
$headers .= "$equipment";
$headers .= "$status";
mail("$to", "$status", "message", "additional headers")
I'm going to use a cron job to do this, and I have other cron jobs
running so it's not a problem to do that. But how do I get the
variables to be able to use? I know I need to use a loop of some kind,
and honestly I have been trying to figure this for a couple of days
and I just can't seem to make it work....sob... :-(
If anyone could show me how to do this I would be ever so grateful as
I have just plain run out of ideas.
Thanks for reading :-)
Nelly