= '" . pg_escape_string($fromDate) . "' AND to_char(a.added, 'YYYY-MM-DD') <= '" . pg_escape_string($toDate) . "' "; } $query = " SELECT 'View' AS edit, a.member_id, b.username, a.ip, a.number, a.added FROM crash_log a LEFT JOIN members b ON (b.id = a.member_id) " . $whereQuery . " ORDER BY a.added DESC "; return $query; } }