Re: Mysqli Error for Count (Distinct) Query

[Eric Hilding]

Thanks for your reply!

There are 10 rows of data in my test database, so maybe I am misunderstanding how things work?

I wondered if maybe my ISP's old MySQL version could be the problem?

So I also tried this with what you kindly provided:

$sql = "SELECT version()";

Got this:

SELECT version() returned no result5.5.14Total

Apparently MySQL v5.5.14

Checked several sources but did not see any "minimum version" requirement for DISTINCT.

Not sure what to do from here.


-Eric