How can I write this query statement correctly?

How should I write this query statement correctly? $ sns $ db-& gt; field (DISTINCT (dname) & nbsp; AS & nbsp; d_name, COUNT (dname) & nbsp; AS & nbsp; tjs)-& gt; where (array (lid & gt; intval ($ _ GET [id]), islottery & gt; 1)-& gt; how can I write this query statement correctly?
$ Sns = $ db-> field ('distinct (dname) 'AS 'd _ name', 'Count (dname)' AS 'tjs ') -> where (array ('lid' => intval ($ _ GET ['id']), 'islottery' => 1)-> GROUP ('dname ') -> order ('tjs desc')-> select ();


------ Solution --------------------
DISTINCT is a keyword, not a function.
It cannot be used as follows: DISTINCT (dname)
It does not work either.
However, it can be placed in a clustering function. for example, count (DISTINCT dname) is used to count the number of states in dname.