* Richard [...] > When the same code is run but without the line: > > AND individual_id ='AB00090004' AND Category = 'DXS1047' > > a fragment of the results is: > > +----------+---------------+------------+-------+---------+---------+ > | category | Individual_ID | Inactivate | count | minkey | maxkey | > +----------+---------------+------------+-------+---------+---------+ > | DXS1047 | AB00090004 | 0 | 1 | 2027223 | 2027223 | > +----------+---------------+------------+-------+---------+---------+ > | DXS1047 | AB00090004 | 0 | 2 | 2063277 | 2064251 | > +----------+---------------+------------+-------+---------+---------+ > > Any ideas why? Any help would be greatly appreciated,
You are not removing the line you say you are removing... this is the expected result when you remove the GROUP BY clause. Check your code... remember that indexed arrays often start at item 0, not item 1... -- Roger query --------------------------------------------------------------------- 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
