Need Help On Fetching Information and 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:

 

 

mail();

[email protected]

  first title

  second title

  third title

  fourth title

 

 

mail();

[email protected]

  first title

  second title

 

 

mail();

[email protected]

  third title

  fourth title

 

 

mail();

[email protected]

  first title

  second title

  third title

  fourth title

 

 

Anyone could help me with this??? IF possible with source code.

[sasa]

try

<?php
mysql_connect('localhost');
mysql_select_db('test');
$sql = 'SELECT email, catid FROM users_table';
$result = mysql_query($sql);
$emails = array();
while ($row = mysql_fetch_array($result)){
$tmp = array();
$tmp['email'] = $row['email'];
$sql = 'SELECT title FROM jobs_table WHERE catid IN ('. implode(', ',explode('~', $row['catid'])). ')';
$result1 = mysql_query($sql);
while ($row1 = mysql_fetch_array($result1)){
	$tmp['contest'][] = $row1['title'];
}
$emails[] = $tmp;
}

foreach ($emails as $email) {
echo 'Email:',$email['email'],"<br />\n",implode("<br />\n",$email['contest']),'<hr />';
}
?>

[andz]

Thanks for the reply. I'll give it a shot. Could I email you incase I have a question???