change date from Y-M-D to M-D-Y and back

Anon

I'm querying and posting to a mysql database where the date is in the date format. YYYY-MM-DD After querying the database, I would like to display the date as MM-DD-YYYY 07-11-2001. I would also like users to be able to enter dates as MM-DD-YYYY and have the dates be posted to the mysql database as YYYY-MM-DD.

<?
$connection = mysql_connect("localhost","root", "connect");
$sql = "SELECT * FROM inventory";
$sql_result = mysql_query($sql, $connection);
$row = mysql_fetch_array ($sql_result)

$body=$row["body"];
$date_entered=$row["date_entered"];
?>

<p>Date Entered:  
<?

/ Print results of the querry /
echo "$date_entered";

?>

I've read some of the php date examples but am confused as how to apply them in my case. Any suggestions? Thanks.

Anon

To get the Date in MM-DD-YYYY format...

Try replacing:
$date_entered=$row["date_entered"];

with this:
$date_entered = date("m-d-Y", strtotime($row[date_entered]));

Are the users typing the dates in a text box or selecting them from drop downs?

Anon

As of right now, users are typing dates in a text box. I would prefer having them select dates from a drop down box.

Anon

I can use; $date_entered = date("m-d-Y", strtotime($row[date_entered])); to convert Y-m-d to m-d-Y but what if I need to do the oposite. How about converting to m-d-Y in order to update a date and then converting the updated date back to Y-m-d before posting to the database?

The input box looks like this:

<?
/*
print("<INPUT ");
print("TYPE=\"text\" ");
print("NAME=\"date_entered\" ");
print("VALUE=\"$date_entered\">\n");
?>

Any ideas?