in reply to PERL and MySQL

Double or triple check what you are putting in $search, $start and $per_page. If they arn't perfect all three can mess up your results. My recommendation would be to drop the limit until you get the search working right. Also make sure that once you put your search in the querry, the query prints out looking exactly like the one you run in phpMyAdmin. Even cut and paste the finished query over and see if it runs there.


___________
Eric Hodges