> I am now getting a completely different error that I cannot
figure
> out how it is related. I have passed the $td variable into the
function
> and
> then get it back as a POST variable from a hidden field within the
> function.
> Here is the error I am now seeing;
>
> Unknown column 'sn42
quot; <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 10:53 AM
Subject: RE: [PHP-DB] Datetime help in an INSERT...
> Do you think URL propagation is a better option than passing another
> variable into the function and then passing it back out through a hidden
> form element? Her
]
Sent: Thursday, June 05, 2003 9:48 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: [PHP-DB] Datetime help in an INSERT...
a button is being pressed?
so it is processing a form?
if its in a form just pass along the value of $td via hidden input data...
jay merritt
[EMAIL PROTECTED]
[EMAIL PROTECTED
lto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 9:01 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: [PHP-DB] Datetime help in an INSERT...
You could alway place it as a "GET"
echo "";
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forw
ROTECTED]
Sent: Thursday, June 05, 2003 9:06 AM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Datetime help in an INSERT...
> I have actually discovered that the $td value is blank. The reason
> appears to be that the page is reloading when a butt
> I have actually discovered that the $td value is blank. The reason
> appears to be that the page is reloading when a button is pushed, and that
> is when the $td value is being lost. My question now is, how do I keep
the
> $td value after the page is reloaded? I would rather keep the value fro
PROTECTED]
Subject: Re: [PHP-DB] Datetime help in an INSERT...
> > 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
> 2. Place single quotes within your VALUES parens, e.g.
If they are really strings. Integers or dates in a MMDD format do not
require quotes.
> $denylog = "INSERT INTO deny (account, td, datefield ) VALUES ('$tmp',
> '$td', NOW() )"
---John Holmes...
--
PHP Database Mailing List (http://
far.
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 2:14 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Datetime help in an INSERT...
> > I am stumbling across something that I thought
m Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 04, 2003 2:06 PM
> To: 'Rankin, Randy'; '[E
> > 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
No, the field is a Datetime field rather than a Timestamp field.
-Original Message-
From: Rankin, Randy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:59 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Datetime help in an INSERT...
Correction ( I typed
ALUES ($tmp, $td )";
Randy
-Original Message-
From: Rankin, Randy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:56 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Datetime help in an INSERT...
If you are using MySql with the date field is of type timestamp, you s
al Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:47 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Datetime help in an INSERT...
The error I am receiving is:
You have an error in your SQL s
The error I am receiving is:
You have an error in your SQL syntax near ' NOW())' at line 1
-Original Message-
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
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
f
16 matches
Mail list logo
