Keith Spiller wrote:
> I am trying to figure out how to use the NOW() function with a MySQL
> Insert command on a Timestamp field.
Okey, either use NOW() on the DATETIME field, or use TIMESTAMP field
without inserting there value.
> Here is my mysql command:
>
> INSERT INTO $tablename
> (sender,
> INSERT INTO $tablename
> (sender, recipient, whenread, whensent, subject,
> messagetext, folder, priority, condition)
> VALUES
> ('$directorid', '$SendTo', '00', NOW(), '$SetSubject',
> '$MessageText', 'Inbox', '$SetPriority', 'TO')
Easy as that!
j- k-
mysql, sql
--
Jo
Hello,
I am trying to figure out how to use the NOW() function with a MySQL Insert
command on a Timestamp field.
Here is my mysql command:
INSERT INTO $tablename
(sender, recipient, whenread, whensent, subject,
messagetext, folder, priority, condition)
VALUES
('$directorid', '$SendTo', '
