Trying to show the next due date...

Anon

Good morning,
I am trying to take the inspection date inputted in the table and show the next due date which is 90-days from that date. $qrtrly is the cell in the table which holds the inspection date.

Am I doing this right? Or am I way off track? Either way it not working out for me.

$nextdue = DATE_ADD($qrtrly ++ 90);

Any help would be gratefully appreciated.

:o) Ivan

mrmufin

The MySQL DATE_ADD syntax is:

DATE_ADD(date, INTERVAL, expr interval)

Where 'date' is a date string or temporal data type representation (in MySQL TIMESTAMP, DATE or DATETIME format, or a similar string which can be used as such), 'expr' is an integer and 'interval' is one of: SECOND, MINUTE, HOUR, DAY, MONTH, YEAR, MINUTE_SECOND, HOUR_MINUTE, HOUR_SECOND, DAY_HOUR, DAY_MINUTE, DAY_SECOND or YEAR_SECOND.

Suppose your table column is named 'checkout' (a temporal column type of DATE) and you want to display a date 90 days from 'checkout' as 'due date':

SELECT DATE_ADD(checkout, INTERVAL 90 DAY) AS 'Due Date' FROM some_table WHERE ... yada-yada-yada...

Anon

I got to it work in mysql, however I can't get the script to display correctly. It gives me a "Resource id #3". The script reads:

$sql = "
SELECT *
FROM insp, lsv
WHERE insp.vid = \"$vid\"
AND insp.vid = lsv.vid
ORDER BY insp.qrtrly DESC
LIMIT 1
";

$nextdue = mysql_query("SELECT DATE_ADD(qrtrly, INTERVAL 90 DAY) FROM insp", $connection);

Thanks for any help.
:o) Ivan