select data from within the last 28 days

[SM777]

I'm trying to select data from within the last 28 days using PHP.

I don't think I'm getting the right results. This is either due to incorrect select or because of the leap year?

$date28 = date("Y-m-d", strtotime("-28 day"));

Is that correct or is there another way to do it?

 

[sleipnir214]

You believe you aren't getting the right results, or you know you're not getting the right results?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[vanekl]

you could try this,

SELECT *
FROM yourtable
WHERE yourdatefield > DATE_SUB( Now(), INTERVAL 28 DAY);