HELP: Getting info from two tables to match
I am using Dreamweaver MX to connect PHP to MySQL. I am currently building a mini-Content Management system.
I have the following tables created:
meeting_date
- date_id
- month
- day
- year
users
- user_id
- firstname
- lastname
- division
agenda
- agenda_id
- subject
- user_id
- date_id
I get the results to display all data dependant upon the date specified (ie. all data appears when a user clicks on the 'date_id' from 'meeting_date'). So if someone click February 15, 2004: The information from 'agenda' displays according to that date.
The problem I am having is displaying the 'division' of the 'users' table related to the 'user_id' inputted in the 'agenda' table. I want to add the field 'division' to the list of data outputted.
So my results are:
February 15, 2004 (meeting_date)
3 (user_id) - *I would like this to be division from 'users' instead of 'user_id'
Subject (agenda)
Can I relate the 'user_id' from the 'agenda' table to the 'division' field of the 'users' table. I would imagine so since the 'user_id' fields are the same.
Thanks to all who can help.
