[decongh]

Hi, Am building a car sale site.I want to automatically take of listings that are more than, say 14 day old.

Any php/mysql scripts or an idea as to how to do this?

[Dormilich]

there are two possible routes in general.
1) make a MySQL function/procedure that only returns those valid listings
2) specify it in the fetching SQL string. something along SELECT item FROM listings WHERE DATE_ADD(item_created, INTERVAL 14 DAY) > NOW()

This post has been edited by Dormilich: 17 January 2012 - 02:40 AM

[decongh]

Thank you for your help.I need one for clarification,is this

item_created

a filed in the db as well?

Thank you for your help.I need one more clarification,is this

[b]item_created[/b]

a filed in the db as well? If so what data type will it be, Date type?

[Dormilich]

it’s the data field where you store the date/time when you created the listing. it would be sensible to define it along

item_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP

[decongh]

Hi Dormilich, am very thankful for your help,it worked just perfect,thanks alot