How can I show the number of visitors yesterday and today on my homepage?
Can you show me an easy way?
this could be achieved with a SQL statement to fetch the count from the phpcounter_days table with given dates for today and yesterday.
for instance for today the query is: $query = "select * from phpcounter_dates where date='".date("Y-m-d")."'";
this should return always the row with the todays statistics.
Log in to post a comment.
How can I show the number of visitors yesterday and today on my homepage?
Can you show me an easy way?
this could be achieved with a SQL statement to fetch the count from the phpcounter_days table with given dates for today and yesterday.
for instance for today the query is:
$query = "select * from phpcounter_dates where date='".date("Y-m-d")."'";
this should return always the row with the todays statistics.