Question
Advance SQL
Ok I need to join two tables which is easy to do, but this is
for an internal email prograM I am making. Now I joined the
databases together but what I need to do is set it so only the user
that is logged in can view the messages that where sent to them.
Also I need to substitute the senders id for the username that sent
the message. Here is my database structure:\
email_email | authorize
--------------------------------
eml_senderid -> id
eml_recipient -> id
Now I set the recipent id to a session variable I declared earlier so that only the message for that user is displayed. Now what do I do to set the senders id to their username?
I am using PHP and mySQL.
email_email | authorize
--------------------------------
eml_senderid -> id
eml_recipient -> id
Now I set the recipent id to a session variable I declared earlier so that only the message for that user is displayed. Now what do I do to set the senders id to their username?
I am using PHP and mySQL.
AdChoices