The error I am receiving is: You have an error in your SQL syntax near ' NOW())' at line 1 -----Original Message----- From: jay@advmed.com [mailto:jay@advmed.com] Sent: Wednesday, June 04, 2003 1:45 PM To: NIPP, SCOTT V (SBCSI) Subject: Re: 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 database > 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, NOW())"; > $denylog_result = mysql_query($denylog, $Prod) or die(mysql_error()); > > Scott Nipp > Phone: (214) 858-1289 > E-mail: sn4265@sbc.com > 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
