VB Coding Help

[DeLeTeD]

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['count']);



$newposts = $db->query_first('
SELECT COUNT(*) AS count 
    FROM ' . TABLE_PREFIX . 'post
    WHERE dateline >= "' . strtotime("-1day") . '"
');
$newposts = number_format($newposts['count']); 

DeLeTeD Reviewed by DeLeTeD on 27th Jun 2010. 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