Appreciation for any help extended up front.

I'm a techie from way back but have been more focused in security, etc over the last 5 years. Now I'm in the position of putting a hobby web site together and I'm way out of date on web design technologies, etc. The particulars:

I'm using Dreamweaver CS3 and a MySQL DB. I need to figure out the best way to create a site that will do something akin to the following:

DB table authors
DB table books

When someone clicks on an author and gets the author info back, incorporated into the display is the author info and a list of all their books. I have no problem creating the SQL recordset (authors-books join) to support the data that needs to be displayed, but where I'm challenged is in the need to make each book reference somehow have a link associated with the displayed title that will pull a book detail record.

I know this has to be basic. I mean look at any typical site today. Most are database driven that result in pages that incorporate dynamically created links in the data that is retrieved.

Any help or direction to tutorials, etc would be much appreciated..

www.w3schools.com and www.htmlgoodies.com have good tutorials to get you in the direction in how to build database driven content using PHP. They will show you the required basics to some more complex features.

You will probably want to use php. They have one of the best documentation sites on the web
http://www.php.net/manual/en/

The page talking about MySQL functions should be a great help.
http://www.php.net/manual/en/ref.mysql.php
It includes many examples.