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 simple
database
table
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 from
, 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 button is pushed, and that
is when the $td
: 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 a href=\yourscript.com/yourpage.php?td=$td\;
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto
]
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...
input type=hidden name=td value=? echo $td; ?
jay
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? Here was another snippet from another suggestion on this.
a button is being pressed?
so
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 'sn4265' in
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 an INSERT
: 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 syntax near ' NOW())' at line 1
($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 should
have to insert
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
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
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'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Datetime help in an INSERT
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 I have
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
15 matches
Mail list logo