Ask a Question
Advertise on boostr.in
codeigniter how to do a select distinct fieldname mysql query using -'php,mysql,codeigniter,distinct'
codeigniter how to do a select distinct fieldname mysql query ¬†using -'php,mysql,codeigniter,distinct'
I'm trying to retrieve a count of all unique values in a field.
SELECT count(distinct accessid) FROM (`accesslog`) WHERE record = '123'
How can I do this kind of query inside of CodeIgniter?
I know I can use $this->db->query(), and write my own SQL query, but I have other requirements that I want to use $this->db->where() for. If I use ->query() though I have to write the whole query myself.
Sep 7, 2015
to add a comment.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please