[Resolved] Displaying "new" icon

Tim_L

Hi,

I'd like to display a little "new" icon next to all products in a directory which are, funnily enough, new! I've got a date (timestamp) for each product which is inserted on adding a new product and updating a product.

I'd like to do a conditional region using the timestamo but I'm not sure what to use - I could do === [current date] but that would only show the icon for that day and I'd like it to be there for about a week or so.

Any ideas?

LordShryku

$oneWeekAgo = strtotime(date("Y-m-d")."-7 days");
if($timestamp > $oneWeekAgo) {
   echo "New";
}

Tim_L

Tried that but it has added it to every product??

LordShryku

Are you sure that's a true timestamp field?

Then again, it's probably a difference between PHP's timestamp and MySQL. You're inserting using now() aren't ya? If that's the case, you may be better off using MySQL's date and time functions

Tim_L

Nope, I am using MYSQL timestamp for the date field - 20031013105638 is an example format.

However, I've probably done something wrong?:

$proddate = strtotime(date("Y-m-d")."-7 days");

 <?php if ($row_rs_results['date'] > "$proddate"){ ?>
              <img src="/images/button_new_sm.gif" alt="New Product!" width="25" height="9"> 
              <?php } ?>

G-Net

Shouldn't it be:

<?php if ($row_rs_results['date'] > $proddate){ ?>

Tim_L

Originally posted by G-Net
Shouldn't it be:

<?php if ($row_rs_results['date'] > $proddate){ ?>

Don't think it matters...

Weedpacket

Originally posted by Tim L
Nope, I am using MYSQL timestamp for the date field - 20031013105638 is an example format.[/code]

That's one problem: MySQL timestamps are a different format from the usual form (where the above-indicated time would be represented as something like 1065995798).

But if you're using MySQL and MySQL time and date formats, why not use MySQL to make the determination whether something is new or not? It's got ADD_DATE, it's got NOW, .....

LordShryku has already suggested this. It's also been suggested in another thread that has appeared in this forum within the last day or two.

Tim_L

OK - I think I've got it now except I don't know how to do the 7 days old thing. I get a parse error with this:

<?php
$proddate = date("YmdHis")."-7 days");
?>

What should I be putting?

Tim_L

Ok - resolved folks!

If anyone wants to know:

$oneWeekAgo = date("YmdHis", (time() - (86400*7)));

^This code displays the date exactly 7 days (1 week) ago^