Ajax Event Calendar Support Product Page
Answered
refining the AJAX query
Asked 25 Feb 2014 12:07:26
1
has this question
25 Feb 2014 12:07:26 Bill Teale posted:
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
Replies
Replied 27 Feb 2014 11:24:47
27 Feb 2014 11:24:47 Teodor Kuduschiev replied:
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.
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.
Replied 27 Feb 2014 11:27:37
27 Feb 2014 11:27:37 Bill Teale replied:
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