title: Php daily, weekly, mounthly registered user count
body: <p>I need help about php count query for registered user daily, weekly and mounthly. So totaly registered user is easy but my mined is confused for daily,weekly and mounthly registered user count. Anyone can tell me how can i do that ?</p>
  
  <p>I have tryed the following code for daily but it didn't work, not have any error or warning.</p>
  
  <pre><code>public function UserDaily(){
    $query = mysqli_query($this-&gt;db,"SELECT * 
    FROM users 
    WHERE FROM_UNIXTIME(registered) &gt; CURRENT_DATE 
    AND FROM_UNIXTIME(registered) &lt; (CURRENT_DATE + INTERVAL 1 DAY )")or die(mysqli_error($this-&gt;db));    
   } 
  </code></pre>