One problem I have come across many times is accepting dates into a form field (perhaps on a cms backend) and needing to format it to another order or date layout to enter into mysql. Commonly since mysql accepts yyyy-mm-dd and I accept dates as mm-dd-yyyy the format needs to be changed from mm-dd-yyyy to yyyy-mm-dd in order for mysql to take it properly. Simply take $yourdate and convert it to $fdate with the php code below. You can change the array number order if you wanted to do something different.