How to get Two day before date

[contactrajiv08]

I want to get two day before date, that will be use in mysql query to get two day before data from current date.

[kiwibrit]

That's a php issue, not an html one. My first thoughts would be to build something around getdate (http://uk3.php.net/manual/en/function.getdate.php). But you're more likely to get a clued up response in the php section of the forum. Maybe a mod will move this post there.

[bokeh]

Do it at query level:SELECT something FROM tbl_name WHERE DATE_SUB(CURDATE(),INTERVAL 2 DAY) = date_col