Datetime help in an INSERT...
| From: | SBCSI) | Date: | Wed, 04 Jun 2003 18:37:26 +0000 |
| Subject: | Datetime help in an INSERT... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28300@lists.php.net to get a copy of this message | ||
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