Re^6: DBI SQL Returns Less than Direct SQL

I ran the COUNT(*) SQL in PHPAdmin and it returned a value of 6 indicating as expected that there were 6 rows that matched the criteria specified in the SQL. When run from PERL, it is returning 1.

Dave

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

Replies are listed 'Best First'.
Re^7: DBI SQL Returns Less than Direct SQL by Corion (Patriarch) on Oct 18, 2011 at 13:55 UTC
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.	[reply] [d/l]

Replies are listed 'Best First'.

Re^7: DBI SQL Returns Less than Direct SQL
by Corion (Patriarch) on Oct 18, 2011 at 13:55 UTC

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.

[reply]
[d/l]