[thelist] quick php/mysql search engine question

Anthony Baratta Anthony at Baratta.com
Thu Sep 12 14:13:01 CDT 2002


At 11:11 AM 9/12/2002, Dunstan Orchard wrote:
>Hi there,
>
>I've got this php script that's supposed to search a MYSQL table and look for
>a matching keyword in a db table field.

Change this: keyword LIKE '$keyword%'");

to this: keyword LIKE '\%$keyword%'");

you need the extra % to match "in front of".
--
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."




More information about the thelist mailing list