Re: [PHP] search query analyzer

[raditha dissanayake]

Paul Godard wrote:

Hi

I am looking for some good ideas to combine some fields with query operators (multiple words, or/and, >/„/¾<, range of numerical values...).

Let's say I have 2 fields (numerical & text) to combine where the serach criteria can 
be as complicated as this :
- year : >1950, 1960-1965, not1980-2000, >2002
- subject : (boy and bicycle) or (man and tractor)
Is there a bullet proof function that can filter such field values and return a valid sql query?
 

I sure hope not, if such things existed in the API we would all be out 
of jobs :-)

before you get started, i suggest taking a look at full text indexing , 
you will find that a lot friendlier than ordinary look ups.

--
Raditha Dissanayake.
---------------------------------------------
http://www.radinks.com/print/upload.php
SFTP, FTP and HTTP File Upload solutions 

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