This is more of a php question. explode $string on " " (space) which will
give you an array. Loop through the array first with $sql.="WHERE
whatevercolumn LIKE '%$val%'" then for every other entry change WHERE to
AND.
Serge.
- Original Message -
From: "Paul Maine" <[EMAIL PROTECTED]>
T
Pada Sat, 27 Jul 2002 21:32:48 -0500
"Paul Maine" <[EMAIL PROTECTED]> menulis :
> $string ="1972 Ford Mustang"
>
> Using the following SQL statement:
> SELECT * FROM whatevertable WHERE whatevercolumn LIKE '%$search%
> I want to return all records that have Mustang AND 1972 AND Ford.
my sugges