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

[Randy Clamons]

There's not really enough information here to tell what's going wrong. It depends on how you are handling your input for the search parameters, and how you validate values for $start and $per_page.

The way your statement is, it may be possible that $start - 1 == -1, if $start is 0. That would cause no results to appear. There could be unexpected characters in the $search value.

Here' what I suggest. In your Perl script, after this line of code, print $query to see what it really looks like. Copy that statement into your query analyzer and see what happens. You might see something that makes some sense.