SELECT COUNT(*) WHERE date='$today'

[JanMolendijk]

Dear admin i try to add a counter but
i want to have the data from only
the current date into it...

This code is not working & what do i do wrong ???

Code: Select all

<?php 
  
include('connection.php');

$today = date('Y-j-n');

$result = $track->query("SELECT COUNT(*) FROM `visitor_tracker`  WHERE date='$today' ");
$row = $result->fetch_row();
echo 'Total Visits ', $row[0];

?>

I thought strange ??? But i had my date-code wrong ( sorry)

Code: Select all

$today = date('Y-n-j');