Hi,
I want to know if I can disable a date in a calendar field depending on the value of a database query please?
If not is it possible to change the background color of the data depending on the same criteria please?

I have a form which allows my user to ask for displaying they ads in my website at a specific day.
So, I would want my calendars fields check the number of Ads in a speficic position at a specific date (with a query) and then either disabled the date if it's fully booked or change its background color to avoid another user to book an Ad display in a fully booked date.

I have ever try to ask the support, they said my ask in the forum, so please, can anybody help me?

I do not want to do the checking at the form validation because when I think as my user, it's annoying. Look forward :
1- I select my date, I submit my form and an error message tell me this date is fully book.
2- I select another day, I submit my form and an error message tell me this date is fully book.
3- I select another day,I submit my form and an error message tell me this date is fully book.
4- ...

and it can take a long time. But if, since the form is loaded, I can notify the user of the date he can choose (by disabled date or change its css) it would be nice and professionnal.

Is it possible for example to get all the fully booked dates in a php table then put some code in the calendar field to disabled the dates stored in the table ? It would be a solution.



Thank you by advance
Regards

Myann