I have the following code<html><head> <title>Eye Contact - Century to Century</title> <link rel="stylesheet" href="eye01.css" type="text/css" /></head><body><form name ="" method = "post" action=""><table width="100%" border="1" height ="85%"><tr height = "15%"><th>Date</th><th>Year Left</th><th>City Origin</th><th>Country Origin</th><th>Year Arrived</th><th>City Arrived</th><th>State Arrived</th><th>Filename</th></tr><?php$db = mysql_connect("localhost","root","");if (!$db){ print "error - Could not connect to MySQL"; exit;}$er = mysql_select_db("touch_art1");if(!$er){ print "error - Could not select the database"; exit; }extract($_POST); $query = "SELECT date, yr_left, city_origin, country_origin, yr_arrival, city_arrival, state_arrival, filename FROM story WHERE country_origin = '$search_country' AND pamapproved = 'Y' ORDER BY yr_left"; $result = mysql_query($query);if($result){ while($column = mysql_fetch_object($result)) { print "<tr align ='center'>"; foreach($column as $colval) { print "<td>$colval</td>"; } print "</tr>"; }}else{ print "Error on Query"; exit;} mysql_free_result($result);mysql_close();?> <input type="hidden" name="" value="none"></table><table height = "15%" width = "100%" border = "0"> <tr height="100%"> <td align="left" valign="top" width="50%" > <embed src="images/home.svg" width="100%" height="100%" wmode="transparent" type="image/svg+xml" /> </td> <td align="right" valign="top" width="50%" > <embed src="images/back.svg" width="100%" height="100%" wmode="transparent" type="image/svg+xml" /> </td> </tr></table></form></body></html>I need to display the date as in MM-DD-YYYY. Can anyone help?
DATE DISPLAY
Posted - 2006-04-23 : 18:50:12
