Using this script to highlight results

sgtpepper

Hi,

I am trying to highlight the results based on a date. For example I have a query that gives me several results. My goal is to use my date field (called mod_date_time) to highlight results that have been listed in the last 10 days. My mod_date_time date format is
2003-10-08 16:43:00.

I am trying to use the code below to highlight the result. It isnt working. Can you offer some help? If I change < to > all results show up as new listing.

I appreciate all your help....

Thanks

<?
$now = date("Y-d-m H:i:s", strtotime("-10 days"));
?>

<?
$newlisting = "$row[mod_date_time]";

if(($newlisting) < '$now') {
$displaynewlisting = "
<table border=0 cellspacing=1 width=100%>
<tr>
<td width=100% bgcolor=#FFFF00>
<p align=center><font size=2><b>New Listing</b></font></td>
</tr>
</table>
";
}
echo $displaynewlisting;
?>

kevinsequeira

hi sgt,
if the earlier threads answered your questions asked for that thread could you pls mark them resolved.
thanks
kevin

sgtpepper

Sorry, they didnt solve the problem...I should have added this to those threads. I'll mark them as resolved to close them out of the loop...but I am still having some problems.

kevinsequeira

<?php
$seconds = 60*60*24*10; // 10 days in seconds;
$record_date = strtotime($row['mod_date_time']);
$today = time();
?>
<table border="0" cellspacing="1" width="100%">
<tr>
  <td width="100%" bgcolor="#FFFF00" align="center">
    <font size=2><b>New Listing</b></font>
  </td>
</tr>
<?php if(($today - $record_date) < $seconds) { ?>
<tr>
  <td width="100%" bgcolor="#FFFF00" align="center">
    <?php echo  $row['mod_date_time']; ?>
  </td>
</tr>
<?php } ?>
</table>

this might work

sgtpepper

This displayed 'New Listing' and the date string on all results.

kevinsequeira

change it to
$record_date = strtotime/b;

reg
kevin

sgtpepper

Sorry, still no go....

New Listings show on all results....

kevinsequeira

are there any records that are greater than 10 days ????
what format is mod_date_time in ?
is there a link to this page that i can take a look
reg
kevin