subject:"\[PHP\] date counting\/subtracting MySQL and PHP"

Re: [PHP] date counting/subtracting MySQL and PHP

2003-10-21 Thread Jason Wong

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". -- Ja

[PHP] date counting/subtracting MySQL and PHP

2003-10-20 Thread Paul Nowosielski

Hello, Can some lend advice regarding date functions using mysql and php please? I have a table set up like so (DESCRIBE nuke.position) hiddenid int(5) PRI NULL auto_increment id varchar(40) contact_email varchar(64) title varchar(60) salary mediumtext disc