PHP SQL - Mysql Joins

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Mysql Joins

amkma

2005-11-15, 11:15 am

I have created two tables. In one I keep user informations like:
User_id,
User_name,
User_email,
User_IP.

In second table I keep message information like:
email_id
email_text
email_sender_id
email_receiver_id
email_date_id
email_title

I want to join these so that it shows like these result:
email title --- email date --- email from --- email to --- email text

I am a newbie. Please help
thanks

Sponsored Links