Search Engine with MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greetings all,

I just serached the records and found this topic.
This nearly answers my question but not completely.

I have a search field and a class that I found that will explode queries
into an array based on boolean values and such.
Which is great so I get all the words a person is searching on and in what
way.

However I am not clear on the best way to query MySQL.

I want to search over four fields in 2 different tables.
Based on what I read below there is an easy way to do with with MySQL but I
am not familiar with it.
Can someone enlighten me on this, it sounds just like what I need.

--
Blessed Be

Phillip

"Ben Edwards" <funkytwig@xxxxxxxxx> wrote in message
news:32b873ff05012004152c1cb9b4@xxxxxxxxxxxxxxxxx
> This kind of depends on what database you are using (I am asuming you
> mean you have a data driven site you want to search so strictly
> speaking it is the database that you want to search).
>
> Mysl has free text search facilities (i.e. you can pass it a number of
> words and it can search for them in a set of database fields and even
> kreates a 'ranking').  however this only works if you have a few
> hundread records - less than this and the results are unpredictable.
>
> Have you tries googeling for php search scripts?
>
> Ben
>
> On Thu, 20 Jan 2005 14:04:44 +0200, Rosen <rosen@xxxxxxxxxxxxxx> wrote:
> >
> > Hi,
> > Can someone recommend me a search engine script in PHP for inside one
site?
> >
> > Thanks in advance!
> > Rosen
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> Ben Edwards - Poole, UK, England
> WARNING:This email contained partisan views - dont ever accuse me of
> using the veneer of objectivity
> If you have a problem emailing me use
> http://www.gurtlush.org.uk/profiles.php?uid=4
> (email address this email is sent from may be defunct)

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux