$count_sent=0;
$count_received=0;
$count_nviewed=0;

$sql = "SELECT * FROM table1 WHERE day = '$d' AND month = '$m_num' and year = '$y' ";

$sth = $dbh->prepare($sql);
$sth->execute() || die $sth->errstr;

while ($pointer = $sth->fetchrow_hashref)
  {
      $count_sent++;
      if (my $status = $pointer->{'status'} eq "2") {
	  $count_received++;}
	  
      if (my $status = $pointer->{'status'} eq "1") {
	  $count_nviewed++;}	  
  }
#Running this it find one entry based on my date as 06/24/2004
print "My results: $count_nviewed<br>";