How the algorithm to display date less 2 week from current date?

atomlife007

I have try to do about php, do the property
i want to system display all the property only less 2 week from currently date. I mean for example: current date: 23/2/2010, it will shoud property of last date 22/2/2010, 21/2/2010 .... 9/2/2010. someone can help me this? give me some coding to do this.Thanks for your help.

bradgrafelman

Are you using a database to store the information? If so, it'd be a simple matter of adding the appropriate condition to the WHERE clause, e.g.:

WHERE date_col >= (CURDATE() - INTERVAL 2 WEEK)

atomlife007

bradgrafelman;10951657 wrote:
Are you using a database to store the information? If so, it'd be a simple matter of adding the appropriate condition to the WHERE clause, e.g.:
WHERE date_col >= (CURDATE() - INTERVAL 2 WEEK)

can i have the code of database ? The database i want to put date and price of each property

bradgrafelman

atomlife007;10951660 wrote:
can i have the code of database ?

You mean you want us to design your entire database structure/schema for you? We can certainly help you do so, but you're going to have to help us as well... for example, you could start by trying to design your own database and including all of the columns you think are necessary to hold the data you have. From there, we can work on optimizing/normalizing it so that it's easy to work with.

atomlife007

Thanks you. i know what you mean but i really new meb i dont know where to starting now. Can you tell me the step need to do ?

Shrike

The first step would be to read some books or articles about web development.