jQuery datepicker, disable dates from MYSQL
Try following code to match your situation which disables set of dates. You can get dates by using json from your mysql table using $.getJSON of jquery
$(function() { $( "#pickdate" ).datepicker({ dateFormat: 'dd MM yy', beforeShowDay: checkAvailability }); }) var $myBadDates = new Array("10 October 2010","21 October 2010","12 November 2010"); function checkAvailability(mydate){ var $return=true; var $returnclass ="available"; $checkdate = $.datepicker.formatDate('dd MM yy', mydate); for(var i = 0; i < $myBadDates.length; i++) { if($myBadDates[i] == $checkdate) { $return = false; $returnclass= "unavailable"; } } return [$return,$returnclass]; }