Display record from a linked table in mysql ...

Hi, I have a problem. I have created a MySql database and now I'm tryin to display the information thru PHP (created in Dreamweaver). Displaying data from a single table is easy. But how do you display data that is related to another table?

For example: I have a "members table" and a "meetings table" which holds all the memberID's that were present at a particular meeting. The meetings table holds the MemberID yet when I want to call the information, I want the Member's name to display, not the MemberID.

IS this easy? Thanks for your help!

Your query should like something like:

select members.name, meetings.id from members, meetings where members.name=meetings.id

Should work, post again if it doesn't....

thanks for the reply silver ... still seem to have be having issues. I don't really understand how all the coding works, as dreamweaver does most of it for you ( I guess I'm gunna have to learn it tho! ) ...

But maybe you know of a good relational database tutorial? mysql, php, dreamweaver?

Otherwise, maybe I could send you part of my php code? Then you have to know what my database tables are etc as well, right?

issues!