I have a problem highlighting data from a filter. In other words, I make the filter and show many dates.
<?php
include("conectar.php");
$quantidade = 1;
$pagina = (isset($_GET ['pagina'])) ? (int)$_GET['pagina'] : 1;
$inicio = ($quantidade * $pagina) - $quantidade;
$sql = "select * from tb_detalhe_trabalhador inner join tb_trabalhador on tb_detalhe_trabalhador.id = tb_trabalhador.id inner join tb_equipamentos on tb_detalhe_trabalhador.id = tb_equipamentos.id ORDER BY tb_trabalhador.id asc LIMIT $inicio, $quantidade";
$qr = mysql_query($sql) or die(mysql_error());
while($exibe = mysql_fetch_array($qr)){
echo "<table>";
echo "<tr><td>Nome:</td>";
echo "<td>".$exibe["Nome"]."</td></tr>";
echo "<tr><td>Morada:</td>"; echo "<td>";
if ($exibe['Morada']){ echo $exibe['Morada'];}else{echo 'N/D';} echo "</td></tr>";
echo "<tr><td>Tipo:</td>";echo"<td>";
if($exibe['Tipo']){ echo $exibe['Tipo'];}else{echo 'N/D';} echo "</td></tr>";
echo "<tr><td>Email:</td>"; echo "<td>";
if($exibe['Email']){ echo $exibe['Email'];}else{echo 'N/D';} echo "</td></tr>";
echo "<tr><td>Alvara Numero:</td>";echo"<td>";
if($exibe['AlvaraNumero']){ echo $exibe['AlvaraNumero'];}else{echo 'N/D';} echo " </td></tr>";
echo "<tr><td>Alvara Validade:</td>";echo"<td>";
if($exibe['AlvaraValidade']){ echo $exibe['AlvaraValidade'];}else{echo 'N/D';} echo "</td></tr>";
The query is still quite large and I would like to highlight all dates that are outdated with a color or something. Can I do this with PHP?