in reply to Re^5: DBI SQL Returns Less than Direct SQL
in thread SOLVED: DBI SQL Returns Less than Direct SQL

I crafted the SQL in PHPAdmin to get what I wanted from the table, tuning it until I was happy with the results. Then I ported it to PERL but simply copying it to the source and plugging in the variable to let me specify the search words when the program ran.

By this technique, I could see what results I expected when the PERL program ran. I will try the COUNT(*) and see what MySQL says.

Dave
  • Comment on Re^6: DBI SQL Returns Less than Direct SQL

In Section Seekers of Perl Wisdom