complex if / while?

[vinny199]

I have the following problem.
I'm setting up a classifieds section on a website for jobs.
When a job is posted, i need all registered applicants looking for a job that a new job matching their criteria has been posted.

I got that to work ok, to some extent.

All applicants get notified that a new job matching their criteria has been posted.

The problem i have is as follow:

An employer can post up to 10 jobs at one time, then pay, and THEN the notification emails to applicants are triggered.

What i cant find out is:

I can get one email sent to each job seeker saying that one job has been posted matching their criteria,

but if 5 jobs have been posted by the same employer, matching their criteria, I cannot get 5 emails with each job reference number sent to each applicant.

Damn! I hope this makes any sense..

Basically, I would need the line:

  $jobtype = $row_rs_emploeyr_emails['PDid'];

to also be looped, although it comes from a different recordset.

I guess I'm very lucky if anyone understand any of this and can help...

mysql_select_db($database_to_octo, $to_octo);
$query_rsmother_notices = "SELECT * FROM cv WHERE cv.job_type='".$row_rs_emploeyr_emails['job_type']."' ";


if ($result = mysql_query ($query_rsmother_notices) )

while ($row = mysql_fetch_assoc($result))     { 
  $email = $row['email'];
  $companyname =  $row['companyname'];
  $jobtype = $row_rs_emploeyr_emails['PDid'];

  // send email 
mail( "$email", "New job on has been posted", 
" 
Dear $name,

A new job $jobtype has been posted which could be of interest to you", "From: [e-mail]" );
    } 
 mysql_query($query_rsmother_notices) or die(mysql_error()); 

Many thanks,

Vinny

[timus]

Hey Vinny

I'm probably not following you correctly but dont you already have the jobtype from your original query?

maybe you need to put your code within a foreach loop?

foreach ($row_rs_emploeyr_emails['PDid'] as $val)
{

mysql_select_db($database_to_octo, $to_octo); 
$query_rsmother_notices = "SELECT * FROM cv WHERE cv.job_type='".$row_rs_emploeyr_emails['job_type']."' "; 


if ($result = mysql_query ($query_rsmother_notices) ) 

while ($row = mysql_fetch_assoc($result))     { 
  $email = $row['email']; 
  $companyname =  $row['companyname']; 
 // $jobtype = $row_rs_emploeyr_emails['PDid']; 
  $jobtype =$val;

  // send email 
mail( "$email", "New job on has been posted", 
" 
Dear $name, 

A new job $jobtype has been posted which could be of interest to you", "From: [email][e-mail][/email]" ); 
    } 
mysql_query($query_rsmother_notices) or die(mysql_error()); 
}

Sorry if I've misunderstood what the problem is but hope this helps

Tim

[vinny199]

no,

you're perfectly understood.
that's exactly what I'm trying to do.

However, it did not work.

I'm not getting any error messages or anything, just no email is trigered at all, whereas without the foreach loop they do.

I'm also sure the $row_rs_emploeyr_emails['PDid'] exist , there are 3 returns
I've tried a few variations aswell, like moving the loop just before the if but no luck.

Now I got it to send the right amount of emails byt doing this:

do { 

if ($result = mysql_query ($query_rsmother_notices) )

while ($row = mysql_fetch_assoc($result))     { 
  $email = $row['email'];
  $companyname =  $row['companyname'];
  $job_type = $row_rs_emploeyr_emails['PDid'];

  // send email 
mail( "$email", "New job on jobs.com ", 
" 
Dear $name,

A new job $job_type has been posted which could be of interest to you", "From: [e-mail]" );
    }  

 mysql_query($query_rsmother_notices) or die(mysql_error()); 
 } while ($row_rs_emploeyr_emails = mysql_fetch_assoc($rs_emploeyr_emails));   

This rightly sends 3 emails, for each matching $row_rs_emploeyr_emails['PDid'];
but unfortunatly, the $job_type value of the email is always the first value retireved, instead of 3 emails with the 3 different $job_type values...which makes it irrelevant.

I just somehow can't get the foreach fuction do do anything,

can you think of something that makes it so?

may thanks,

Vinny

[timus]

Hi Vinny

Sorry for the delay

What i've told you about the foreach loop is not quite right. By the sounds of it you've fetched a record or row from a table and one of the columns is PDid so you only have one PDid which is why you're always getting the same job type.

Two ways you can get round this are use a while statement to fetch each PDid and within that loop run your current code (minus the do statement) or you could get all the PDid's and put them into an array and add a count within ur while statement and access that part of the array every time you loop through.

I'd probably try the nested while statement

The foreach statement works with an array, but you dont have an array - $row_rs_emploeyr_emails['PDid'] is a reference to a single value.

Sorry to misleading

Tim