Unanswered: Retrieving partial data from MySQL database using PHP and Dreamweaver MX
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 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!