Re: PHP/MySQL Search Engine Query Question

2002-07-28 Thread Serge Paquin
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

Re: PHP/MySQL Search Engine Query Question

2002-07-28 Thread Dicky Wahyu Purnomo
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