I have seen that many people are searchign for date formatting for dd-mm-yyyy format while mysql default supports yyyy-mm-dd , here is a function which flip the date. I hope you will find it useful

<?php
function flipdate($dt, $seperator_in = '-', $seperator_out = '-')
{
return implode($seperator_out, array_reverse(explode($seperator_in, $dt)));
}
?>