0000-00-00 displays as 11/30/-0001 in results page
I've got a Mysql database with a date field I need to have some date records that are blank. I've created a search, results and detail page and on the detail page any blank dates display ad 11/30/-0001 rather than display ad blank. How can I adjust the code so that the blank field is displayed as nothing rather than 11/30/-001. By the way... if I update the record and put nothing in the field it displays as 12/31/1969. I solve that by specifically deleting anything in the field before I update it... but then I get the 11/30/-0001. When I look at the table in PHP MyAdmin it's displayed as 0000-00-00