Cool - thanks Jim. Appreciate the helpful reply.
--- In php_mysql@yahoogroups.com, Jim Mullen <j...@...> wrote:
>
> Try:
>
> $query =
> "SELECT id, description, date, requester, year, notes
> FROM $table
> WHERE description LIKE '%keyword%' OR notes LIKE '%keyword%'";
>
> However, if description and notes are text data type then you should use
> the MySQL MATCH syntax.
>
> Best regards,
> Jim
>
> iDimensionz <http://www.idimensionz.com> - professional web site
> programming, affordable web site hosting.
>
