datetime formatting problem

hi all - this is probably straight forward, but i'm learning and would appreciate any insight. i'm using the datetime type in mysql and have been able to successsfully pull the data records's date, but it's failing out and giving me the current time [as in what it says on my system's clock] basically i'm just spitting out all the rows to an html table and would like to have the date AND time formatted as is in the date(...) function at the top of the code demo. thanks! matt ///// begin code demo function formatDate($val) { $arr = explode("-", $val); return date("M d, Y g:i A", mktime(0,0,0, $arr[1], $arr[2], $arr[0])); } // open database connection $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); // select database mysql_select_db($db) or die ("Unable to select database!"); // generate and execute query $query = "SELECT * FROM outdoor ORDER BY id ASC"; $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); // if records present if (mysql_num_rows($result) > 0) { // iterate through resultset // print title with links to edit and delete scripts while($row = mysql_fetch_object($result)) { ?> <tr> <td><? echo $row->id; ?></td> <td><? echo $row->name; ?></td> <td><a href="mailto:<? echo $row->email; ?>"><? echo $row->email; ?></a></td> <td><? echo $row->zip ?></td> <td><? echo formatDate($row->date); ?></td> <td><? echo $row->club_member ?></td> <td><? echo $row->driver ?></td> <!-- <td><font size="-1"><? echo $row->active ?></font></td> --> <td><center><a href="edit.php?id=<? echo $row->id; ?>"><img src="notepad.gif" alt="" width="16" height="16" border="0"></a> &nbsp; <a href="delete.php?id=<? echo $row->id; ?>"><img src="trashcan.gif" alt="" width="16" height="16" border="0"></a></center></td> </tr> <? } }