php alternative to Now() -7

[metalllus]

Hi, im developping a blog site. On this site every blog post gets a date when it gets posted in the formart of date("Y-m-d H:i:s"). On one of my pages on the frontend of the site i want to display only posts that are 7 days old or younger. I am following a Lynda.com course which describes this whole thing, but it is for ASP and i am using PHP/MySQL. In the course a new recordset gets created which looks like this:

SELECT intPostID, vchPostTitle, intPostBy, dtePostDate, intCatID, txtPostContent, tblusers.vchNickName
FROM tblblog, tblusers
WHERE intPostShow = 1 AND tblBlog.intPostBy = tblUsers.intUserID AND tblblog.dtePostDate > MMColParam
ORDER BY dtePostDate DESC

In the variables window a new variable gets created, which looks like this:
Name:MMColParam
Type:Date
Default Vaue: 2003-01-01
Run Time Value: Now() -7

The Now() -7 function is a VBscript function, so i need something that can do the same, but using PHP. Plz help.

[Newsgroup_User]

metalllus wrote:
> On one of my pages on the
> frontend of the site i want to display only posts that are 7 days old or
> younger.

Do it with your SQL query.

> SELECT intPostID, vchPostTitle, intPostBy, dtePostDate, intCatID,
> txtPostContent, tblusers.vchNickName
> FROM tblblog, tblusers
> WHERE intPostShow = 1 AND tblBlog.intPostBy = tblUsers.intUserID AND
> tblblog.dtePostDate > MMColParam
> ORDER BY dtePostDate DESC

Change it to this:

SELECT intPostID, vchPostTitle, intPostBy, dtePostDate, intCatID,
txtPostContent, tblusers.vchNickName
FROM tblblog, tblusers
WHERE intPostShow = 1 AND tblBlog.intPostBy = tblUsers.intUserID AND
tblblog.dtePostDate >= DATE_SUB(NOW(), INTERVAL 7 DAY)
ORDER BY dtePostDate DESC

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[metalllus]

it works just fine, thx a lot.

[Newsgroup_User]

metalllus wrote:
> it works just fine, thx a lot.

Glad to be of help.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/