Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
Strange. MySQL says a certain number of rows are returned, but then there's no data whatsoever.
I've looked at the query, I've troubleshoot'ed every which way, and yet this happens, repeatably (often it's when I want a single colum of all distinct values for a field).
Has any one else experienced this?
My intial query is this ...
SELECT DISTINCT field FROM table ORDER BY field
... and if I then change it to ...
SELECT field, COUNT( * ) FROM table GROUP BY field ORDER BY field
... it works fine (I just have to ignore the 2nd column in the resulting data).