[RESOLVED] removing 2 weeks from a date

Desbrina

I have this code

   $currDay = date('w');
   $weekStart = date('Y-m-d', ($currDay == 6 ? time() : strtotime('last Saturday')));
   $weekEnd = date('Y-m-d', ($currDay == 5 ? time() : strtotime('Friday')));
      $sql = mysql_query("SELECT *
            FROM staffpay
            WHERE `date` >= '$weekStart'
               AND `date` <= '$weekEnd'
               AND `name` = 'Obi-Wan'
               AND `type` = 'Saturday'
            LIMIT 1") or die(mysql_error()); $result = mysql_num_rows($sql);

which works fine for anything for the past week, but i need to change it so that it checks for the past 2 weeks

tapos

You can Try this sql. This sql give you the result set which is exactly within last 15 days.

$sql = mysql_query("SELECT *
            FROM staffpay
            WHERE `date` >= SUBDATE(NOW(),15)
            LIMIT 1") or die(mysql_error());

Hope this will work.

Thanks
Tapos Pal
http://tapos.wordpress.com

Desbrina

although that works, if someone takes it on a Wednesday, they have to wait till 2 weeks Wednesday not the Saturday

tapos

You can use mysql date functions to use your logic.

--
Thanks
Tapos Pal
http://tapos.wordpress.com