Newbie Question

Anon

Hi, I created a small task script for the office, (of course with the help of some of you guys) and I just want to know is it possible to have the priority cell or number change colors when the task is over 15 days old? The script is below:

$sql = "

SELECT *
FROM $table_name
WHERE (status<>'Completed' AND status<>'Canceled')
ORDER BY priority
";

$result = @($sql,$connection) or die("Couldn't execute query.");

$the_task = "

<tr>

<td bgcolor=#4040FF>Subject:</td>

<td bgcolor=#4040FF>Priority:</td>

<td bgcolor=#4040FF>Submitted By:</td>

<td bgcolor=#4040FF>Workcenter:</td>

<td bgcolor=#4040FF>Phone:</td>

<td bgcolor=#4040FF>Assigned To:</td>

<td bgcolor=#4040FF>Status:</td>

</tr>

while ($row = mysql_fetch_array($result)) {

$id = $row['id'];

$date = $row['date'];

$subject = $row['subject'];

$priority = $row['priority'];

$calledinby = $row['calledinby'];

$workcenter = $row['workcenter'];

$phone = $row['phone'];

$assignedto = $row['assignedto'];

$status = $row['status'];

$the_task .= "<tr>

<td bgcolor=#ECDC94><a href=\"show_individualtask.php?id=$id\">$subject</a></td>

<td bgcolor=#ECDC94>$priority</td>

<td bgcolor=#ECDC94>$calledinby</td>

<td bgcolor=#ECDC94>$workcenter</td>

<td bgcolor=#ECDC94>$phone</td>

<td bgcolor=#ECDC94>$assignedto</td>

<td bgcolor=#ECDC94>$status</td>";

}

$the_task .= "</table>";

Thanks for any help...

:o) Ivan

jordy

Assuming the date is in MM-DD-YYYY format:

put this code ABOVE this line: '$the_task .= "<tr>'

if (ereg ("([0-9]{1,2})-([0-9]{1,2})-([0-9]{4})", $date, $ret)) {
if ($ret[2] > ($date["j"]+13)) { $color = "red"; } else { $color = "green"; }
} else {
echo "Invalid date format: $date";
}

Change this line '<td bgcolor=#ECDC94>$priority</td>' to:

<td bgcolor=$color>$priority</td>

GR>Jordy Querner

fitzbean

$sql = "
SELECT *, NOW() - INTERVAL 14 DAY as oldtask
FROM $table_name
WHERE (status<>'Completed' AND status<>'Canceled')
ORDER BY priority
"; // ADDED THE oldtask field