[PHP-WIN] Query problem

Hi This is more oriented into the field of SQL, any suggestions? I am searching for a query that yields what my code below does "in the sql" In a "three table join" I am looking for the rows that have the highest value of "COUNT(we_employee.IDe)", in case two (or more) rows have the same value -

Re: [PHP-WIN] query problem

Make sure you have the AutoIncrement bit set on the table. -- Scott Carr Documentation Maintainer OpenOffice.org Quoting Frank Tudor <[EMAIL PROTECTED]>: > I am using php on unix and have moved my pages and > database over from a win 2k server. > > I rebuilt the databases > > and figured the

[PHP-WIN] query problem

I am using php on unix and have moved my pages and database over from a win 2k server. I rebuilt the databases and figured the pages would work right. I have an mediumint set to null in my mysql database the code issues a null value and on windows it increments properly. on unix it increment