Blocking data from sql table from showing up

I have a sql database which includes a table of data where we keep detailed information on all our workshops. As we go into next year, there are certain workshops that we will not be offering.

We have used DA to organize our workshops on our website for the public to access. However, I am uncertain how to keep the workshops that we are not offering next year from showing up on the webpage.

Of course, DA is pulling the data from our sql database table. Is there a way, using DA, to block out some of the workshops without deleting the data (workshops) from the table?

Here is a link of our workshop page...seminars.php

Note - each workshop has its own "PresentID" which identifies it.

Thank you.

add a new column to the table for status.

for active workshops, set the value of this column to 1, for non active use 0.

in the query that returns the workshops, add a where clause:

WHERE status = 1

to return only active workshops.