Re: date counting/subtracting MySQL and PHP

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 */