On Wednesday 22 October 2003 04:32, Paul Nowosielski wrote: > I need to get mysql or php to subtract the current date from > $date_posted(time stamp) and return the number of days(the item has been > posted) as a sum.
Use the MySQL function TO_DAYS(). Not sure what you mean by "as a sum". -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* Children aren't happy without something to ignore, And that's what parents were created for. -- Ogden Nash */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
