reotto
04-02-2009, 07:59 AM
Does anyone know how to edit the below code where it states ($subscription['email'],....so the email will be sent to field5@field6 for individuals with a subscription?
$subscriptions = $db->query("
SELECT subscriptions.userid, username, email
FROM " . ADV_DYNA_TABLE_PREFIX . "subscribeentry AS subscriptions
INNER JOIN " . TABLE_PREFIX . "user AS user ON (subscriptions.userid = user.userid)
WHERE entryid = '$entryid' AND user.lastactivity > '$entry[dateline]' AND subscriptions.userid != '$userid'
");
while ($subscription = $db->fetch_array($subscriptions))
{
eval(fetch_email_phrases(ADV_DYNA_PREFIX . '_subscribe_entry2', 0));
vbmail($subscription['email'], $subject, $message);
}
}
?>
$subscriptions = $db->query("
SELECT subscriptions.userid, username, email
FROM " . ADV_DYNA_TABLE_PREFIX . "subscribeentry AS subscriptions
INNER JOIN " . TABLE_PREFIX . "user AS user ON (subscriptions.userid = user.userid)
WHERE entryid = '$entryid' AND user.lastactivity > '$entry[dateline]' AND subscriptions.userid != '$userid'
");
while ($subscription = $db->fetch_array($subscriptions))
{
eval(fetch_email_phrases(ADV_DYNA_PREFIX . '_subscribe_entry2', 0));
vbmail($subscription['email'], $subject, $message);
}
}
?>