Search-Engine for MySQL an Weblike Requests!

From: Date: Tue, 06 Jun 2000 11:19:08 +0000
Subject: Search-Engine for MySQL an Weblike Requests!
Groups: php.general 
Request: Send a blank email to php-general+get-1124@lists.php.net to get a copy of this message
Hi! I'm looking for a class or function, which provides the construction of a MySQLQuery-String directly from an enterd searchstring like:'+"the rock" +movie -geography' Additional, the function should allow to enter the tablename, the fields (in which I want to search) and the fields I want to receive. The function should return something like that: 'SELECT id, description FROM tablemovie WHERE ((name LIKE "%the rock%")OR(content LIKE "%the rock%"))AND ((name LIKE "%movie%")OR(content LIKE "%movie%"))AND NOT((name LIKE "%geography%")OR(content LIKE "%geography%")) Does anyone know, where I can find this function? Else I have to code it myself, but I'm to lazy for it! ;) Regards, Oliver.

« previous php.general (#1124) next »