Date Comparison Code

[acpaulley]

Hello. I learn best by seeing something in action...

One of columns in my table is a date that the record was added.

When I am outputting my data, what would the code be to compare the current date with the date the record was added and if that date is within the past 7 days, show a "NEW" icon...? In real time? i.e., as it makes the table?

In this case, the "date added" field is called "dateadded".

Thanks,
Aaron

[fengpi]

Here's one way to do it:

Let's say you added a a new article to your news article table and the date added is: 2003-03-02 12:10:23. Assume the 'dateadded' field is the 'datetime' data type.

Do your output, then do something like this in the while loop:
[FONT=courier new]
while ([some code here ]){
if(){
// do some kind of comparison here
}
}
[/FONT]

But, it might be cleaner to do it in the SQL query. Let's say you have this query:
[FONT=courier new]
$sql = "
SELECT
id,
title,
body,
dateadded,
(.............................)
FROM articles
limit 10 order by dateadded
";
[/FONT]

the big blank, (.............................) is where you can use a function to compare dates and it will return 1 or 0. Refer to they MySQL manual for what I'm talking about.

Then use the 1 or 0 to decide whether to display the NEW image.