[RESOLVED] Sending too many emails

[bo0]

I have a script that takes information from one table (ufJoin) and using its results grabs information from two other tables (users and feeds). Using the information gathered then utilizes a pre-made function and sends an email.

For example:
ufJoin contains userid 1 and feedid 1. So the script looks in the users table for the userid matching 1 and takes their email addresses. The script then looks in the feeds table for the feedid matching 1 and takes its url.
The table ufJoin will contain more than one entry per user. Meaning, more than one URL is to be used.
The URLs found are then attached to a pre-made function and emailed.

My problem:
It sends a new email for every URL instead of just the one! How can I stop this from happening?

[help_wanted]

it would be best if you provided your current code.

Then people would be able to look at your code and give you advice.

[bo0]

As requested:

<?


?>

[jatinder]

I think the following code will work for you. I have moved the

mail($row['email'], Title, $body); out of the while ($ds=mysql_fetch_array($url_q)) {
loop.

<?php
require_once "_functions.php";

// retrieve those userids that have a corresponding entry in the ufJoin table
$query = "SELECT users.userid AS userid, users.email AS email
    FROM users, ufJoin
    WHERE users.userid=ufJoin.userid
    GROUP BY users.userid";
$result = safe_query($query);

// deal with each user separately
while ($row = mysql_fetch_assoc($result)) {
	// retrieve those urls that correspond to this userid
	$url_query = "SELECT feeds.url AS url
        FROM feeds, ufJoin
        WHERE ufJoin.feedid=feeds.feedid
            AND ufJoin.userid={$row['userid']}";

$url_q = safe_query($url_query);
// generate
$cnt =0;
while ($ds=mysql_fetch_array($url_q)) {
	$url_row=$ds['url'];
	//myfunction here
	$body .= $url_row;
	$cnt++;

}
mail($row['email'], Title, $body);
unset($body);
unset($url_row);

echo "Mail complete.";

}
?> 

[bo0]

Thank you very much. It is all working now!
Cheers!