ID: 13799 Updated by: sander Reported By: [EMAIL PROTECTED] Old Status: Open Status: Feedback Old Bug Type: *Database Functions Bug Type: MySQL related Operating System: Windows 98 PHP Version: 4.0.6 New Comment:
Probably not a bug in PHP, but in your script. Can you provide a sample script? Previous Comments: ------------------------------------------------------------------------ [2001-10-23 08:46:49] [EMAIL PROTECTED] Using MySQL through the Apache server with a reproduction of the Northwind database (as supplied by MicroSoft). The command: SELECT DISTINCT Customers.* FROM Customers, Orders WHERE Customers.CustomerID = Orders.CustomerID; This works OK when executed by MySQL in DOS (returning 20 records in my version of the Northwind Database). In PHP the command also returns 20 records but PHP incorrectly reports "Showing records 0-30 (387)" at the top of the page. If I leave out the 'DISTINCT' command I get the full 387 records with a correct report "Showing records 0-30 (387)". I amend the query as follows: SELECT DISTINCT Customers.* FROM Customers, Orders WHERE Customers.CustomerID = Orders.CustomerID ORDER BY Customers.CustomerID; PHP now shows the same 20 records and declares "Showing records 0-20 (20)" this time correctly. ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=13799&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
