php-db | 2002122

Re: [PHP-DB] Searching DB and Printing Results From: Jeffrey_N_Dyke <email protected>
Date: 12/30/02

this can be done with Full Text Searching....depending on DB compatability.

if you use mysql - http://www.mysql.com/doc/en/Fulltext_Search.html

HTH
Jeff

                                                                                                                         
                    "Mike Delorme"
                    <crazymonkey1385 <email protected> To: php-db <email protected>
                    tmail.com> cc:
                                              Subject: [PHP-DB] Searching DB and Printing Results
                    12/30/2002 11:53 AM
                                                                                                                         
                                                                                                                         

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 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php