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

 

[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?