Why won't this produce Mysql date format

[ozlad]

Hi,

I have been playing around with this all day.
Could someone please tell me why this code won't produce the date in Mysql format. It is producing e.g 2005-5-25, I needs to be 2005-05-25. It is more than likely something simple that I am missing.

<?php
$date = "0";
$monthnames = array(01=>"January","February","March","April","May","June","July","August","September","October","November","December");

if($date = $myrow["date"]) {
$datearray = explode("-", $date);
echo "<SELECT name=\"day\">\n";
echo "<OPTION VALUE=\"" . $datearray[2] . "\" READONLY>" . $datearray[2] . "</OPTION>\n";
echo "</SELECT>\n";
echo "<SELECT name=\"month\">\n";
echo "<OPTION VALUE=\"" . $datearray[1] . "\" READONLY>" . $datearray[1] . "</OPTION>\n";
echo "</SELECT>\n";
echo "<SELECT name=\"year\">\n";
echo "<OPTION VALUE=\"" . $datearray[0] . "\" READONLY>" . $datearray[0] . "</OPTION>\n";
echo "</SELECT>\n";
} else {
$datearray = explode("-", date("Y-m-d"));
echo "<SELECT name=\"day\">\n";
for($d = 01; $d <= 31; $d++) {
if($d == (int)$datearray[2]) {
echo "<OPTION VALUE=\"" . $d . "\" SELECTED>" . $d . "</OPTION>\n";
} else {
echo "<OPTION VALUE=\"" . $d . "\">" . $d . "</OPTION>\n";
}
}
echo "</SELECT>\n";
echo "<SELECT name=\"month\">\n";
for($m = 01; $m < 13; $m++) {
if($m == (int)date("m",mktime(0,0,0,$datearray[1],1,0))) {
echo "<OPTION VALUE=\"" . $m . "\" SELECTED>" . $monthnames[$m] . "</OPTION>\n";
} else {
echo "<OPTION VALUE=\"" . $m . "\">" . $monthnames[$m] . "</OPTION>\n";
}
}
echo "</SELECT>\n";
$now = date(Y);
echo "<SELECT name=\"year\">\n";
for($Y = $now; $Y <= ($now+2); $Y++) {
if($Y == (int)$datearray[0]) {
echo "<OPTION VALUE=\"" . $Y . "\" SELECTED>" . $Y . "</OPTION>\n";
} else {
echo "<OPTION VALUE=\"" . $Y . "\">" . $Y . "</OPTION>\n";
}
}
echo "</SELECT><BR>\n";
}
?>

I am using this as an include file.
Any help would be greatly appreciated.