email notification

From: Arjan (c)
Date: 11/30/03


Date: Sun, 30 Nov 2003 18:42:04 +0100

I have the following 2 tables

+++++++++++
emailnotification
+++++++++++
userid
topicid
+++++++++++

+++++++++++
user
+++++++++++
id
email
etc...
+++++++++++

Now i want the following:
My addreply.php (a page from my forum) must look if there is a topicid (in
table "emailnotification") the same as $topic.
If there are... he has to take the userid.
With help of the table "user" they have to find the email-adresses.

Soo... for example $mailnick become:
$mailnick = info@arjan.nl, info@arjan.nl;

Can anyone help me? Thanx already



Relevant Pages

  • Re: email notification
    ... On 2003-11-30, Arjan wrote: ... he has to take the userid. ... FROM user INNER JOIN emailnotification ON ...
    (alt.php)
  • Re: email notification
    ... "Arjan" a écrit le 30/11/2003: ... he has to take the userid. ... $sql = "SELECT e.userid AS userid, e.topicid AS topicid, u.email AS ...
    (alt.php)