Hi Everyone,
Have a little problem. I have a database that I update vehicle inspection dates on a quarterly basis. My problem is when I added a new one to the database, my output shows all of the dates. I have 20 vehicles and I want it to display those 20 with the current inspection date not the old date with the new. The code is below.
$sql = "
SELECT *, insp.qrtrly + INTERVAL 90 DAY as nextdue
FROM lsv, insp
WHERE lsv.org = \"$org\"
AND (lsv.vid = insp.vid)
ORDER BY insp.qrtrly
";
Thanks for any help!
:o) Ivan R.
