The error I am receiving is:
You have an error in your SQL syntax near ' NOW())' at line 1
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:45 PM
To: NIPP, SCOTT V (SBCSI)
Subject: Re: [PHP-DB] Datetime help in an INSERT...
what kind of error are you getting?
> I am stumbling across something that I thought I have done before,
> and I am not having any luck finding an example of this. Basically, I am
> wanting to timestamp the date and time into new entries in a simple
> table. The following section is the actual code for this, and I cannot
> figure out how to get the date/time stamp to populate into the database.
> Thanks in advance for the help. I suspect this is a very simple fix.
> $denylog = "INSERT INTO deny (account, td, date) VALUES ($tmp, $td,
> $denylog_result = mysql_query($denylog, $Prod) or die(mysql_error());
> Scott Nipp
> Phone: (214) 858-1289
> E-mail: [EMAIL PROTECTED]
> Web: http:\\ldsa.sbcld.sbc.com
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php