I am using a PERL script and am having some probs with it....
Expand|Select|Wrap|Line Numbers
- $query = sprintf (
- "SELECT `Cats`.`Name`,`Address`.`Address`,`Address`.`City`,`Contact`.`Phone`
- FROM
- (
- `Cats`
- LEFT JOIN
- `Address`
- USING (`Name`)
- LEFT JOIN
- `Contact`
- USING (`Name`)
- )
- WHERE
- `Cats`.`Category` LIKE '%$search%'
- ORDER BY name LIMIT %d,%d",
- $start - 1, # number of records to skip
- $per_page + 1);
- }
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' or 'furniture repair' 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