Hi everyone,

I have a table with 4 columns in it, ID,Category,Name,Keywords

I am trying to select the entries that have keywords that are
submitted from a form. However, it does not always find the entry.
For example if I select 'agriculture' from the form, I get a blank
result when I know that there is an entry for 'agriculture'.....

I am using this code

$query = sprintf (
"SELECT Category,Name
FROM valley
WHERE Keywords LIKE '%$search%'
ORDER BY name LIMIT %d,%d",
$start - 1,
$per_page + 1);
}

The strange thing is if I run this query through phpMyAdmin, I get no
results either.

There is an entry with agriculture in the keywords.


farm, educational, voluntary, organization, governmental, agriculture

Can anyone spot anything?

Thanks!
Jim