Jim, > Situation.. main table in a relatively small database. Table contains > approx 370K rows. Table is indexed on the unique identifier. New table, > fresh import of clean data. > > Querying on a single field... run from the command line, returns 3 rows, > run from phpMyAdmin, returns 3 rows. Identical query (I echoed it to > make sure) run from a PHP page returns only 2 of the rows. Each record > has a unique identifier - 2 of the rows otherwise identical. > > I've tried retrieving the output on the result set, by row, and by > object but the problem appears to be before the output since I check > number of rows returned and it says only two... > > Got to be missing something painfully obvious here... anyone? Posted > here as I'm not sure whether I'm running up against a PHP problem or a > MySQL problem.
When in PHP are you using zero-based array processing? For more intelligent assistance, please show: a) the PHP code section b) the PHP results c) comparative/correct output from the MySQL command line Regards, =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php