It wasn't workign for me, I didn't notice you need to ADD A PHRASE.
Secondly the split SQL code between lines wasn't working, I had to change it to this:
PHP Code:
// ### Registered Today ##
$newusers = $DB_site->query_first(' SELECT COUNT(*) AS count FROM ' . TABLE_PREFIX . 'user WHERE joindate >= "' . strtotime("-1day") . '" ');
$newmembers = number_format($newusers['count']);
// ### Registered Today ##
Now its working fine on 3.07