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

Then I would really, really make sure that the two programs are connecting to the same database indeed. Consider using the mysql command line program to cross-check the results.

If MySQL tells Perl that there is only one row, and Perl only returns one row, the two are consistent. If MySQL tells Perl one thing and PHP another thing, I highly doubt that the two are talking to the same database instance.

In Section Seekers of Perl Wisdom