Something wrong
#1
Hey,
If I use this query

$query = $db->simple_select("users", "COUNT(uid) AS activeusers", "lastvisit > '$timecut'");

 $activeusers = my_number_format($db->fetch_field($query, "activeusers"));


And then I get it using this {$activeusers}, it works but it gives me the total registered members instead.

Any idea?
Reply
#2
did you declare what $timecut equals to...


$timecut = TIME_NOW - 86400;
We can't help everyone, but everyone can help someone - Ronald Reagan
Did you know? Your question has already been answered. But you haven't searched it yet.
Don’t  Forget to “Mark as Solved” after the fix
Reply
#3
(2015-05-31, 06:28 AM)mmadhankumar Wrote: did you declare what $timecut equals to...


$timecut = TIME_NOW - 86400;

That did the trick, thank you!
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)