this query
select distinct field, field, field...
from
table
where condition
in phpMyAdmin returns, not the number of distinct records but the number of records I would get if I didn't include the word distinct. this a bug in phpMyAdmin?
Thanks, Sam