Thank you Justin for your comments. Yes, I am using MySQL with the column datatype set to timestamp. So the #1 step is to convert the column info into a workable format, #2 do the math, #3 then convert result back into the correct format to update the table.
I have used DataAssist and SecurityAssist to query, authenticate and update the tables with multiple (6 to 27) columns with only 2 or 3 columns using the timestamp datatype.
$row_WAATKtblMySql['passExpireDate'];
How would I use the MySQL UNIX_TIMSTAMP() function to have the query return a php timestamp? Or should I just change the format within the code?
I found this example but I can’t get it to work.
<?PHP
// converts $unix_timestamp to "normal" formated_datetime:
$formated_datetime = DATE("Y-m-d H:i:s",$unix_timestamp);
// produces a timestamp that looks like "YYYY-MM-DD 24:00:00":
$formated_datetime = DATE("Y-m-d H:i:s");
// takes $formated_datetime and converts to "UNIX timestamp":
$unix_timestamp = STRTOTIME($formated_datetime);
?>
