RE: [PHP-DB] INSERT question...
| From: | SBCSI) | Date: | Wed, 20 Nov 2002 20:49:04 +0000 |
| Subject: | RE: [PHP-DB] INSERT question... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23536@lists.php.net to get a copy of this message | ||
Thanks a bunch. That fixed me right up. Still learning a lot about
PHP and MySQL. Hopefully I will be able to remember this as I am sure this
issue will come up for me again in the future.
-----Original Message-----
From: 1LT John W. Holmes [mailto:holmes072000@charter.net]
Sent: Wednesday, November 20, 2002 2:47 PM
To: NIPP, SCOTT V (SBCSI); 'Aaron Wolski'; php-db@lists.php.net
Subject: Re: [PHP-DB] INSERT question...
> $query = "INSERT INTO accounts (
id-sys, rtime)
> VALUES('".$accnts[0]."',
> 'NOW()')";
Remove the quotes around NOW(). It's a function, not a string.
---John Holmes...