Doctoral Level CEUs for courses not expired

Status: 

Closed

Priority: 

N/A

Test URL(s):

References:

Request(s):

Implemented: Add date filter to retrieve and display only courses that are not expired

Content from database:
Retrieve courses from table “fbu_extcal_courses

Example SQL:
Update the existing SQL to ‘enddate‘ > today (courses that are not expired) 

$fbu_extcal_query = ” SELECT * FROM fbu_extcal_courses WHERE programs LIKE ‘%500%’ AND display = ‘Y’ AND language LIKE ‘%$language_nm%’ AND startdate > ‘2020-01-01’ ORDER BY startdate DESC”;

3 thoughts on “Doctoral Level CEUs for courses not expired”

Leave a Comment