Re: datetime formatting problem

Isn't "date" a reserved word? > 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>   > <a href="delete.php?id=<? echo $row->id; ?>"><img > src="trashcan.gif" > alt="" width="16" height="16" > border="0"></a></center></td> > </tr> > <? > } > } > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >