I would normally use a MySQL query to filter out entries that have a zero in the APPROVED field - is this possible to work into the AJAX query too? The MySQL query would be something like SELECT * FROM CALENDAR WHERE APPROVED = 1
Hello Bill, After our conversation i think it will be more painless and easier if you create a view and use it instead of modifying the query. You can create a VIEW from your database events table and filter the results by APPROVED = 1. Then you can use this view in the calendar.
Hi Teodor, after we talked I felt brave and took a look at the ajax file created. I didn't realize there was a Mysql query there, I added AND APPROVED = 1 to the query, that should work right? I didn;t change anything else