> How do I convert the unix time stamp (the one I get by the time()) to a > readable English language time.... > > I am getting data from mySQL by the "now()" function....
Unix timestamps in PHP and the result of NOW() in MySQL are totally different. You'd use the date() function in PHP to format a Unix timestamp. You'd use the DATE_FORMAT() function in MySQL to format a MySQL timestamp. You'd use the TO_UNIXTIME() function to convert a MySQL timestamp into a Unix timestamp. Does that help? ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php