At 15:58 28/09/99 +0200, Jeppe Sohn Jensen wrote:
>I am making a news modul for my website based om a mysql server. I'm letting
>the users add news to the site (If they have a password). I also let them
>set a start day and a stop day for the news they add. How can i be shure
>that the date format is right? If i type a wrong date eg. 1999-13-32 it will
>show as 0000-00-00 in the table.
>Can i do a date check insert before i insert the data??
>Thanks in advance
Wouldn't it be simpler to check *after* the insert then warn & delete it if
it is 0?