Display contents from a Table

[VictorValdez]

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.

[stolzyboy]

And what's the reason of double posting?

Tis' a rule here, don't double post. You have this exact same post in the Database Forum (where it should be).

Just because you are using DWMX is really a moot point.