jquery ui datepicker input not posting to PHP

jquery ui datepicker input not posting to PHP

I'm having problems posting the selected date from the datepicker. I want to add it into my form so people can simply select a date and it will insert it with the form into the mysql database.

It works fine sometimes... but when other people use it or I try on random machines it will just post "0000-00-00" as the date.

Here is how I'm doing it: (I've trimmed alot of unimportant info from it)

  2. <?PHP
  3. mysql_connect("localhost", "xxx", "xxx") or die(mysql_error());
  4. mysql_select_db("xxx") or die(mysql_error());
  7. if(isset($_POST['submit'])) {

  9. //Prepare all form and check for errors
  11. if(Trim(stripslashes($_POST['jsdate'])) == '') {
  12. $hasError = true;
  13. } else {
  14. $date = $_POST['jsdate'];
  15. }
  16. if(!isset($hasError)) {

  19. //Insert Form into Database 
  20. mysql_query("INSERT INTO table (date, blah, blah) ")
  21. VALUES
  22. ('$date', '$blah', '$blah')
  23. or die(mysql_error());
  25. }
  26. ?>
  28. <html>
  29. <head>
  30. <script type="text/javascript" src="src/jquery-1.4.2.min.js"></script>
  31. <script src="src/jquery.validate.pack.js" type="text/javascript"></script>

  33.  <script type="text/javascript" src="src/jquery-ui-1.8.10.custom.min.js"></script>
  34.  <link type="text/css" href="src/smoothness/jquery-ui-1.8.10.custom.css" rel="stylesheet" />

  36. <script type="text/javascript">
  37. $(document).ready(function(){
  38. $("#assign").validate();
  39. $('#jsdate').datepicker({ dateFormat: 'yy-dd-mm' });
  40. });
  41. </script>
  42. </head>
  43. <body>
  47. <form id="assign" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

  49. <input type="hidden" name="salesperson" id="salesperson" value="<?php echo "$session->username";?>" />
  51. <tr>
  52. <td>Lead Date:</td>
  53. <td>
  54. <input type="text" class="jsdate" id="jsdate" name="jsdate">
  55. </td>
  56. </tr>
  57. <tr>
  58. <td></td>
  59. <td><input type="submit" name="submit" value="Add Lead"/></td>
  60. </tr>
  61. </form>
  62. </table>
  64. </body>
  65. </html>