Search - Whole Words

Thanks Jason for replying! Not too familiar with mysql and tried your suggestion (by pasting it on the list page), but im getting an error. It think its because i am searching on multiple fields. Right now, this is how my form is...do you have a suggestion on searching multiple fields within that table?

<form name="search" method="post" action="search.php">

<input name="title,content_keyword,subtitle_keyword,category,author,summary_keyword,contents_keyword,about_the_author_keyword,category_keyword" type="text" id="textfield" size="17">

<input name="submit" type="image" value="Search" src="images/images/search_btn.jpg" alt="" align="left" width="37" height="48">
</form>

I am searching multiple fields on a table called "books"
This is what i have on the listviewer.php

list($booksRecords, $booksMetaData) = getRecords(array(
'tableName' => 'books',

Hi newB,

First, let's change your text field to have a simpler name:

<input name="keyword" type="text" id="textfield" size="17">

Next, we can set up a foreach to loop over the fields you want to search to build up a where clause:

<?php
$escaped_keyword = mysql_escape( @$_REQUEST['keyword'] );
$fields = array('title','content_keyword','subtitle_keyword','category','author','summary_keyword','contents_keyword','about_the_author_keyword','category_keyword');
$where = '';
foreach ($fields as $field) {
if ($where) { $where .= ' OR '; }
$where .= "`" . $field . "` REGEXP '[[:<:]]" . $escaped_keyword . "[[:>:]]' = 1";
}

list($booksRecords, $booksMetaData) = getRecords(array(
'tableName' => 'books',
'where' => $where,
'allowSearch' => false,
);
?>

Does that work for you? Please let me know if you have any questions.

Chris, that worked out very well! Thank you!