Have you tried using phpmyadmin with the sql and see what results it returns?
Lock Down Reviewed by Lock Down on . VB Coding Help Well I created this code rather fast. I just can't seem to make it get the correct number results. I know I am over looking something small. $newusers = $db->query_first(' SELECT COUNT(*) AS count FROM ' . TABLE_PREFIX . 'user WHERE joindate >= "' . strtotime("-1day") . '" '); $newmembers = number_format($newusers); Rating: 5