= '" . pg_escape_string($fromDate) . "' AND to_char(blocked, 'YYYY-MM-DD') <= '" . pg_escape_string($toDate) . "' "; } $query = " SELECT id, ip, reason, blocked, " . " 'Unblock' " . " AS ACT " . " " . " FROM block_ip WHERE id > 0 " . $whereQuery . " ORDER BY id ASC "; return $query; } }