date help

[karthikeyan_coder]

Hello,

        I am having a table with a timestamp field.

id::  inserteddate

1 :: 2007-01-19 21:22:23  11 weeks

2 :: 2007-01-23 21:22:23  10 weeks

3 :: 2007-01-29 21:22:23  9 weeks

4 :: 2007-02-19 21:22:23  7 weeks

5 :: 2007-02-26 21:22:23  6 weeks

6 :: 2007-03-03 21:22:23  5 weeks

7 :: 2007-03-19 21:22:23  3 weeks

 

if i want to select rows started before 6 weeks...

then the result should be

5 :: 2007-02-26 21:22:23  6 weeks

6 :: 2007-03-03 21:22:23  5 weeks

7 :: 2007-03-19 21:22:23  3 weeks

 

if i want to select rows started before 9 weeks then

result should be

3 :: 2007-01-29 21:22:23  9 weeks

4 :: 2007-02-19 21:22:23  7 weeks

5 :: 2007-02-26 21:22:23  6 weeks

6 :: 2007-03-03 21:22:23  5 weeks

7 :: 2007-03-19 21:22:23  3 weeks

 

any help?

 

 

 

[chronister]

It's not perfect, but here is the bulk of what you want to do.

 

 

<?php
$weeks=6; // set your weeks here or create your own

$d= 7 * $weeks ; // take the number of weeks you want and multiply by 7 to get total days

$weeks_ago=mktime(0, 0, 0, date("m"), (date("d")-$d),   date("Y")); //create unix time string based on a date in the past

$match_string= date("Y-m-d h:i:s",$weeks_ago); // format the date to compare to

$query="SELECT * FROM -table- WHERE inserteddate <= '$match_string' "; // we select everything that is less than or equal to our match string.
?>