Query Help

Ivains

Hi Everyone,
I am trying to view only the overdue records. The date is recorded in the database as the date it was accomplished. The next due is 90 days out. I want to view the ones that have passed the 90 day mark.

Any help would be greatfully appreciated:

$sql = "
SELECT *, insp.qrtrly + INTERVAL 90 DAY as nextdue
FROM lsv,insp
WHERE (lsv.vid = insp.vid)
ORDER BY nextdue

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

$the_lsv = "

<tr>

<td bgcolor=#800000>Registration:</td>

<td bgcolor=#800000>Serial Number:</td>

<td bgcolor=#800000>Organization:</td>

<td bgcolor=#800000>Office Stmbol:</td>

<td bgcolor=#800000>Phone:</td>

</tr>

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

$vid = $row['vid'];

$reg = $row['reg'];

$sn = $row['sn'];

$org = $row['org'];

$offsym = $row['offsym'];

$vco_n = $row['vco_n'];

$vco_e = $row['vco_e'];

$nextdue = $row['nextdue'];
$nextdue=date('d M Y',strtotime($nextdue));

$the_lsv .= "<tr>

<td bgcolor=#808080>$offsym</td>

<td bgcolor=#808080>$nextdue</td>
";
}

$the_lsv .= "</tr></table>";