I have a quick question that may be easy to solve, but has me lost anyway.

We are a speakers bureau and we have a static website that we are trying to convert into a data-driven site. I've already set up the databases and established connectivity through Dreamweaver. What I'm having a problem with is the search page.

Once a user does a search for a specific speaker I want the search results to list the speaker name that links to the speakers bio page (which I'm using Dreamweaver templates for) and underneath that link, I want only a portion of that speaker's bio to be listed in paragraph form, so it will look something like this:

<Speaker Name>
Speaker bio...blah...blah....<click here to see more>.

Anybody have an idea of how my select statement should look? I've been searching the web and different tutorials and I can't seem to find anything!

Thanks for any help.

--T

then display SpeakerName and BioExcerpt, and use SpeakerID in formatting the href

Thanks so much for the tip...who knew it could be that easy!