Re: [PHP-DB] Returning a formated dat

2001-02-02 Thread Adam Younce
Ben, The easiest (and quickest) way I've done this in the past is to use MySQL's DATE_FORMAT function when doing the SELECT. To format it like you want try this: SELECT DATE_FORMAT(date_column, '%m/%d/%y') as f_date FROM Table_name; Be sure to use the correct name for the column

[PHP-DB] Oracle TNS problems with PHP4?

2001-02-02 Thread Mark Farver
I am running Oracle 8.0.5 Net8 drivers on a Win95 system using Apache and PHP4.04pl1. I'm getting consistent TNS No service errors from PHP using all three methods of accessing Oracle (oracle,oci,odbc). ODBC works fine in other apps, and the SQLPlus and tnsping work fine (even when called from a