MySQL Forums
Forum List  »  PHP

Re: Mysqli Error for Count (Distinct) Query
Posted by: Eric Hilding
Date: May 13, 2019 08:34PM

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.


Options: ReplyQuote

Written By
Re: Mysqli Error for Count (Distinct) Query
May 13, 2019 08:34PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.