Thank you Daryl for replying to my post. It has part of the puzzle. I miss the days when everyone in the programming community help each other. I first searched the forum for clues and had found your thread.
Perhaps is it just the stress that I am under, but I have not found a clear and accurate document or book that puts everything together. I have looked at php.net and mysql.com but I still don’t clearly see the whole picture. My application involves using the timestamp values from the db schema in mathematical formulas, updating mysql timestamp columns with results and echoing some of the results for the users. From what I have read this involves seconds, integers and converting data formats. On the web there seems to be a lot of inaccurate examples and disinformation. Hopefully, others in the forum that have run into this or the WA gurus, which have been so helpful before, can help clarify this for me and for other members.
There is another useful Webassist link php-scripts/ with a code script to Format Dates.
Functions used:
datediff
strtotime
abs
floor
***** Current Test Code Results ****
<?php
echo strtotime($row_WAATKtblmembers['passActivation']), "\n";
echo strtotime($row_WAATKtblmembers['passExpireDate']), "\n";
?><br />
MATH FUNCTION TEST AREA DAYS LEFT 2:<br />
<?php
$passExpireDate = $row_WAATKtblmembers['passExpireDate'];
$passActivationDate = $row_WAATKtblmembers['passActivationDate'];
$seconds = abs(strtotime($passExpireDate) - strtotime($passActivationDate));
$passDaysLeft = floor($seconds);
echo $passDaysLeft;
?>
Screen Display:
TEST CODE:
1251777600 1252555200
1252419760
MATH FUNCTION TEST AREA DAYS LEFT 2:
1252555200
