Some queries work, some don't.....

[Jim Farthing]

Hi everyone,
I am using a PERL script and am having some probs with it....

I have the following code....

$query = sprintf (
"SELECT * FROM Cats
where category LIKE '%$search%'
ORDER BY name LIMIT %d,%d",
$start - 1,
$per_page + 1);

Of course the actual script is much longer, but I believe the problem is in here somewhere....

In my DB, I have the following entry:

Middle River Restorations, LLC
Furniture Repair
Furniture Repair, Restoration, Stripping, Refinishing, Chair Canning & Weaving, Residential & Commercial, Moving, Flood and Fire Damage insurance, Custom Fireplace Mantels

If I do a search for 'furniture' I get nothing, if I search for 'repair' it comes up..... BTW in the quoted text above, the first line is name, the second is category and the third is keywords and I am searching on category.

This is driving me nucking futz.....

Any suggestions? I can/will post more of the code if needed.

Thanks!
Jim