note 7108 deleted from function.odbc-exec by jimw
| From: | jimw@php.net | Date: | Fri, 14 Dec 2001 19:21:16 +0000 |
| Subject: | note 7108 deleted from function.odbc-exec by jimw | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-22639@lists.php.net to get a copy of this message | ||
For ODBC/Access/MS date fields:
<PRE>
$newMonth = date("m") + 3;
$NewExpDate = date("Y-m-d H:i:s",mktime
(date("H"),date("i"),date("s"),
$newMonth,date("d"),date("Y")));
$stmt = odbc_prepare($conn,"UPDATE
tablename SET fieldname='$NewExpDate'
WHERE id=$id");
if (!$stmt) die ("<b>Error:</b>
Failed to prepare update.");
$success = odbc_execute($stmt);
if (!$success) die ("<b>Error:</b>
Failed to prepare update.");
</PRE>