SamJ

Thank you for the pointer. I will keep chipping away. I have uploaded the SQL export of the table. If you have the time and energy any further help would be appreciated. Cheers sql.txt

Thank you @gizmola, that worked! I've been reading information on the array functions you used; I feel like I am running before I have learned to walk! I can print the days of the week each row will be trigged. To extract the list of events the will be trigged today; my initial thought is to search the array against the current day. If today is in the array, then it will be trigged and should be displayed. The same logic can apply for the following days. I have successfully searched against an array without using a function with arraykeys. But I am struggling to search the code you provided. Can you provide any advice how this can be achieved? Thanks again.

Unfortunately, this is not possible. This is software created by a company, who's core software is based on the data.

Hi, I haven't used PHP to create my own code for a few decades. Please go easy on me. I am working with a MySQL database that runs a schedule. The schedule works from the recurrence column, with seven numbers (0 or 1). These numbers represent the days of the week (Monday to Sunday). 1s will trigger an event, 0s will not. For example, if the recurrence column has 1000000, the task will only trigger on a Monday. 1100100 will trigger on Mondays, Tuesdays and Fridays There are also fields for start date and end dates. I would like to use PHP to extract the current days schedule. Can anyone provide advice on how this can achieved? Example table Recurrence Startdate Enddate Descrption 1000000 20/02/2024 20/02/2030 Task1 1100100 28/02/2024 02/03/2024 Task 2 I'm confident that if someone can point me in a direction of "best approach", I can muddle my way through and learn along the way. Thanks.