Hello,
We have a website which pulls data from its MS Access backend database and
publishes the data using Cold Fusion.
The Cold Fusion code has '#DateFormat(end_date, "Mmmm d, yyyy")#'.
'end_date' is a table column of type DATETIME in the Access DB.
Now, we need to use PHP instead of Cold Fusion to query the same Access
database and display the data on the web. Here are the related PHP code
snippets.
Query the Access DB:
$qry = odbtp_query("SELECT end_date,title,projectID FROM projects ORDER
BY end_date DESC");
Get the query results:
while( ($rec = odbtp_fetch_array($qry)) ) {
echo "end_date is $rec[0]<br>";
}
The outputs of the above echo are:
end_date is Object
end_data is Object
....
The date format I want the output to be is like 'March 31, 2005'. I've
tried PHP's date() function using format 'F j, Y'. The format looks
correct. But date() requires the time it's converting be a timestamp. So
how should I output the 'end_date' in the 'F j, Y' format?
I'd appreciate any help.
Bing
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
