[RESOLVED] nested loop i think

[slimjim]

Can anyone tell me how to do this please.

I have 2 table

First table list email titles
Second tables has members in it

I want to query to get title and loop thru members and send email to each member with a title from first table

Then loop thru first table and get second title and send email to members again

And do this until all members get and email with each title.

So can anyone tell me how to do this.

I sorta went like this but it stopped after the first title

query table 1
while{
query table 2
while{
//did mailing here
}
}

Problem is it only got first title and sent all members the first title, and stopped and never looped thru to get any more titles to email

I need it to work like this:
send all members a email with first title
loop again and repeat and send members second title and keep sending members a email for each title until we sent an email to each member for each title.

If you can get me started somewhere..

So any help would be greatfull

[chasiv]

// query table 1 
$strSQL = "SELECT titles FROM table1";
$result = mysql_query($strSQL);
while ($row = mysql_fetch_assoc($result)) {
    $strSQL2 = "SELECT members FROM table2 WHERE Title = query1.title";
    $result2 = mysql_query($strSQL2);
    while ($row2 = mysql_fetch_assoc($result2)) {
           // get member info
          // send e-mail
   }
}

I believe that is what your trying to accomplish. You want each member to get a separate e-mail correct? (Otherwise they will have your mailing list --- which is not very user friendly for those of us who hate SPAM).

[slimjim]

Thank You I just figure that out last night and it worked too