I am using PHP3.0.16 on Apache 1.3.12 and Mysql 3.22.25 on a Linux machine (Redhat) with downloaded and compiled softwares as mentioned above.
In PHP, the select distinct <fieldname> clause doesnt reurn distinct record on one field. But in Mysql when thru Mysql Client I give the same distinct query, it returns correctly.
Why ?
Moroever instead of distinct, group by <field1> order by <field1> also doesnt return unique records on <field1> and they are not sorted either in that order.
Is this a serious BUG in php-mysql functions or somewhere. I mean it seems to work correctly in Mysql alone but not thru PHP.
What other reason could there be ?
This needs examination, If this is true for others as well.
In PHP, the select distinct <fieldname> clause doesnt reurn distinct record on one field. But in Mysql when thru Mysql Client I give the same distinct query, it returns correctly.
Why ?
Moroever instead of distinct, group by <field1> order by <field1> also doesnt return unique records on <field1> and they are not sorted either in that order.
Is this a serious BUG in php-mysql functions or somewhere. I mean it seems to work correctly in Mysql alone but not thru PHP.
What other reason could there be ?
This needs examination, If this is true for others as well.