[PHP-DB] date problems

2007-09-06 Thread rDubya
mysql_timestamp, 4, 2), substr($mysql_timestamp, 6, 2), substr($mysql_timestamp, 0, 4)); $sformatted_date = date("D M j", $stimestamp); return $sformatted_date; } My problem is that I have events dated for Sep 2007 and on, and yet they all come up as being on Dec 7 to 9, 2006.. an

Re: [PHP-DB] date problems

2007-09-06 Thread rDubya
uses PHP 5 server, with MySQL 4.1 (I'm not 100% sure what the old was.. I think it was PHP 4, and while I think it was the same MySQL version, it could have been an earlier one). Cheers! rDubya also, here is the code that actually displays the events: it then displays the event informati

Re: [PHP-DB] date problems

2007-09-07 Thread rDubya
e new database stores the date as -MM-DD HH:MM:SS. All I had to do was adjust my code to pull only the values and none of the delimeters (ie. "-", " ", and ":"). DUH!!! But once again, thanks you guys for all the help rDubya On 9/7/07, Instruct ICC <[EMAIL