Re: Searching DB and Printing Results

This may be of use: http://www.mysql.com/doc/en/Fulltext_Search.html D. "Mike Delorme" <crazymonkey1385@hotmail.com> wrote in message news:F167PP1F5QVlbtghjuK00026a22@hotmail.com... > > > > > Hi, > > I have a table in DB Music that looks a little mike this: > > TABLE NAME > _____________________________________________________ > SONG NAME SONG LYRICS > | | | | > | | | | > | | | | > | | | | > | | | | > | | | | > | | | | > | | | | > | | | | > | | | | > |_______________________| |__________________________| > > In each row of SONG NAME is the name of a song and the corisponding lyrics > are in the next colum. What I would like to do is set up a search in wich > the client can enter a sequence of words. The search searches the DB table > TABLE NAME and looks for the word sequence in the table. The printed results > are the song name and a link to the lyrics. Can this be done? And how can it > be done? > > Thanks, > Michael Delorme > www.HybridFusion.com > > _________________________________________________________________ > Protect your PC - get McAfee.com VirusScan Online > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 >