HELP: Getting info from two tables to match

[VictorValdez]

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 can 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.

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.

[bastien]

select u., a. from
users u,
agenda a,
meeting_date d
where
u.id = a.id and
a.date_id=d.date_id and
d.date_id = $dateChosenByUser

the astriks indicates that all fields are to be taken

hth

[VictorValdez]

Thank you. I will post how it turns out.

To be sure: d.date_id = $dateChosenByUser

means that 'ChosenByUser' is the recordset name I created?

Thank you

[bastien]

no...that is the date that comes from the form...web page AS CHOSEN BY THE USER