uot;;
$where = "WHERE ($Field LIKE '% ".(preg_replace("/[\s]+/", " %' $Op $Field
LIKE '% ", $string))." %')";
$sql = "SELECT * FROM Table ". $where;
----- Original Message -
From: "Bruno Ferreira" <[EMAIL PRO
"WHERE ($Field LIKE '% ".(preg_replace("/[\s]+/", " %' $Op $Field
LIKE '% ", $string))." %')";
$sql = "SELECT * FROM Table ". $where;
----- Original Message -
From: "Bruno Ferreira" <[EMAIL PROTECTED]>
T
Martin E. Koss wrote:
I have a product database which can be searched for a keyword in up to 3
fields; using this select query:
$sql_select = "SELECT * from productlist WHERE (Name LIKE
'%$SearchText%') OR (Description LIKE '%$SearchText%') OR (Keywords LIKE
'%$SearchText%') ORDER BY Name";
What I
you might use the IN keyword.. like SELECT * FROM table WHERE word IN ('i',
'want', 'to', 'search').
http://php.net/explode
http://php.net/implode
http://php.net/split
- Original Message -
From: Martin E. Koss
To: [EMAIL PROTECTED]
Sent:
Hi all you experts who have help me often in the past, may I now ask
what is probably so simple for someone doing PHP everyday...
I have a product database which can be searched for a keyword in up to 3
fields; using this select query:
$sql_select = "SELECT * from productlist WHERE (Name LIKE
'