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. -- Jason

[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