help with time?

[eluser]newbie boy[/eluser]
guys, tried your solution but only list down to the time exact duration...

doesn't display other things that falls to a certain time duration...

[eluser]Thorpe Obazee[/eluser]
Ok. I don't think I am getting what you want... Do you want to know 'when' something was bought?

[eluser]newbie boy[/eluser]
sorry, works now...

whoaw...

thanks guys....

i know i can count on you...

[eluser]newbie boy[/eluser]
guys one more...

i also need to rank all things/products which had been bought in the same time duration...

[eluser]Thorpe Obazee[/eluser]
Without much explanation about the ranks, I'd assume you'd be using order_by?

[eluser]newbie boy[/eluser]
guys, how can i make the query for the 3 weeks duration will not fetch the duration from the a week duration since this ...

Code:

SELECT * FROM `table` WHERE `date_field` < NOW() + 1814400

will also fetch duration under its total like for the a week...

[eluser]Thorpe Obazee[/eluser]

Code:

SELECT * FROM table WHERE DATETIME > date_a AND DATETIME < date_b

[eluser]newbie boy[/eluser]
doesn't work guys...

still fetches all all data...

[eluser]Thorpe Obazee[/eluser]
I really hope you learn to use Google or the search function:

Code:

http://ellislab.com/forums/viewthread/117545/

[eluser]slowgary[/eluser]
That doesn't make sense newbie. If you're fetching results from within 3 weeks ago, you WOULD include the results from within 1 week ago. You WOULD NOT omit results from within 1 week ago, since they are still from within 3 weeks ago. If a user selects the "3 weeks" option and doesn't get a particular result they're looking for from 6 days ago, your software is broken. But you do what you want to do.

I won't be responding to any more of your posts as I feel you should be posting this in the job board and offering someone skilled a paycheck for completing it. You are not doing what a developer would do, which is to seek out answers to problems. You are asking over and over and over for someone else to write each line of your application.

No hard feelings, I just don't agree with your criteria for what warrants posting on these forums.