How to get respective information ready for email

[andz]

I have these tables and sample contents:

 

jobs_table

  id, title, catid, content

 

  1, first title, 1, first content

  2, second title, 1, second content

  3, third title, 2, third content

  4, fourth title, 2, fourth content

 

 

category_table

  catid, name

 

  1, first category

  2, second category

 

 

users_table

  email, name, catid

 

  [email protected], test user, 1~2

  [email protected], test2 user, 1

  [email protected], test3 user, 2

  [email protected], test4 user, 1~2

 

 

I already knew how to make the catid in users_table readable.

 

I'm trying to send an email. The email contains the job title of the jobs linked by the catid the users choose.

 

My problem is that, how can I load all the users and the same time the job information to be ready for the email?

 

The expected output will be:

 

 

[email protected]

  first title

  second title

  third title

  fourth title

 

[email protected]

  first title

  second title

 

[email protected]

  third title

  fourth title

 

[email protected]

  first title

  second title

  third title

  fourth title

 

 

Sorry for my poor grammar.

 

I already done certain email functions, but this one gives me a little problem. I don't know where to start. Though I already started it by getting all the users information, extract catid array into readable array. Fetch all the information from job table based on catid for every user,,, but it seemed to have a problem.

 

thanks and more power...

 

If posible, pls include codes...

[php_tom]

If you have all th information in an array, just concatenate the info as a string (in an email newlines are '\n'). Like so:

<?php
$message = $data['user1email']."\n".$data['user1title1']."\n".$data['user1title2']."\n";
$message .= $data['user1title3']."\n".$data['user1title4']."\n\n";
$message .= $data['user2email']."\n".$data['user2title1']."\n".$data['user2title2']."\n\n";
$message .= $data['user3email']."\n".$data['user3title3']."\n".$data['user3title4']."\n\n";
$message .= $data['user4email']."\n".$data['user4title1']."\n".$data['user4title2']."\n";
$message .= $data['user4title3']."\n".$data['user4title4']."\n\n";
$subject = "Data extracted from database";
$to = "[email protected]";
mail($to, $subject, $message);
?>

 

Hope that helps.