title: PHP AJAX Countdown Timer
body: <p>I'm looking to use this countdown timer</p>
  
  <p><a href="http://keith-wood.name/countdown.html" rel="nofollow">http://keith-wood.name/countdown.html</a></p>
  
  <p>but I need it to countdown until a specific time from a time entered in a MySQL database. The time is in 23:00:00 format</p>
  
  <p>Here is what I have so far. Just don't know how to plug the time into the JavaScript.</p>
  
  <pre><code>&lt;?php
  
  include('function.php');
  $data = mysql_query("SELECT * FROM lockpick WHERE date= CURDATE()");
  $row = mysql_fetch_row($data);
  $EndTime = $row['EndTime'];
  ?&gt;
  
  &lt;script type="text/javascript"&gt;
      $(function() {
          var austDay = new Date();
          austDay = new Date(austDay.getFullYear() + 1, 1 - 1, 26);
          $('#defaultCountdown').countdown({until: austDay});
          $('#year').text(austDay.getFullYear());
      });
  &lt;/script&gt;
  </code></pre>