jQuery Datepicker

[CryptoN]

Hi,

 

I have a database with a table containing different dates. These dates have different "status". The status can either be 1 or 2. If the status is 2, the appropriate date should be marked with red background.

Exampel, if the date 2010-09-28 has the status 2 in the table, then 28 should be marked with red background in the table.

Here are som code:

 

<?php
  include("../db.php");

  $query = "SELECT published FROM calendar WHERE status=2";
  $result = mysql_query($query)
    or die(mysql_error());

  while($row = mysql_fetch_array($result))
  {
   $published = $row['published'];
  }
   



?>
  <script>
  $(document).ready(function() {
    $("#datepicker").datepicker({
   beforeShowDay: function(date) {
        var array_data = date;
        var mysql_data= ["<?php echo $published; ?>"];

       
      if(jQuery.inArray(date,mysql_data) > -1)
      {
           // Here should the date be redmarked.
         }
         else
         {
            return new Array(true, 'not_taken', 'Den här dagen är öppen: '  + date.toString("yyyy-MM-dd"));
         }
    }
  });
});