CodeIgniter How To Do a Select Distinct Fieldname MySQL Query

Question

I m trying to retrieve a count of all unique values in a field   Example SQL   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- gt db- gt query    and write my own SQL query  but I have other requirements that I want to use  this- gt db- gt where   for  If I use - gt query   though I have to write the whole query myself

User · Answer

try it out with the following code  function fun1             this- gt db- gt select  count DISTINCT accessid            this- gt db- gt from  accesslog          this- gt db- gt where  record     123          query  this- gt db- gt get         return  query- gt num rows

User · Answer

Since the count is the intended final value  in your query pass   this- gt db- gt distinct     this- gt db- gt select  accessid     this- gt db- gt where  record    record     query    this- gt db- gt get  - gt result array    return count  query     The count the retuned value

User · Answer

You can also run - gt select  DISTINCT  field    FALSE  and the second parameter tells CI not to escape the first argument  With the second parameter as false  the output would be SELECT DISTINCT  field  instead of without the second parameter  SELECT  DISTINCT   field

User · Answer

Simple but usefull way    query    this- gt db- gt distinct  - gt select  order id  - gt get where  tbl order details   array  seller id    gt   seller id            return  query

User · Answer

record    123     this- gt db- gt distinct      this- gt db- gt select  accessid      this- gt db- gt where  record    record      query    this- gt db- gt get  accesslog      then   query- gt num rows      should go a long way towards it

[php] CodeIgniter: How To Do a Select (Distinct Fieldname) MySQL Query

Examples related to php

Examples related to mysql

Examples related to codeigniter

Examples related to distinct