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

[CrapH]

i had same code saved somewhere

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

cant see why it wouldnt work

did you update counters?

[DeLeTeD]

yea I updated the counters with no success.

[Lock Down]

Are you getting any results or an error?

[DeLeTeD]

I get results

New Users Registered Today: 41 
New Posts Posted Today:  1 

New posts always stays at 1-3
and users registered moves around but the number is off

[Lock Down]

Have you tried using phpmyadmin with the sql and see what results it returns?