: Monday, July 28, 2003 2:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Date insert
Hello,
I have the following PHP code:
$date = date(Y-m-d H:i:s);
$result = mysql_query(INSERT INTO Boats (Make,
Model, Serial,
Stock, Extension, Cust_Name, Store, Date) VALUES
Budelak wrote:
This is how I implemented a similar though not exactly the same problem:
$tempdate = gmdate(d-m-Y);
$insertSQL = sprintf(INSERT INTO gennews (newsdate, newsheadline,
country, newsfull) VALUES ($tempdate, %s, %s, %s);
So, you only have to change the format of the gmdate what you
Hello,
I have the following PHP code:
$date = date(Y-m-d H:i:s);
$result = mysql_query(INSERT INTO Boats (Make, Model, Serial,
Stock, Extension, Cust_Name, Store, Date) VALUES
('$make', '$model', '$serial', '$stock', '$extension',
'$name', '$store', '$date')
:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Date insert
Hello,
I have the following PHP code:
$date = date(Y-m-d H:i:s);
$result = mysql_query(INSERT INTO Boats (Make,
Model, Serial,
Stock, Extension, Cust_Name, Store, Date) VALUES
and see if you still get the error.
-Original Message-
From: Andrew D. Luebke [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 2:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Date insert
Hello,
I have the following PHP code:
$date = date(Y-m-d H:i:s
From: Andrew D. Luebke [EMAIL PROTECTED]
$date = date(Y-m-d H:i:s);
$result = mysql_query(INSERT INTO Boats (Make, Model, Serial,
Stock, Extension, Cust_Name, Store, Date) VALUES
('$make', '$model', '$serial', '$stock', '$extension',
'$name', '$store',
here. Try changing the field name and give that a shot. I think I am
actually right here though.
Scott
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 1:19 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL Date insert
Don't know about
:
Subject: [PHP-DB] MySQL Date insert
07/28/2003 02:16
;
Michele Petrovsky
- Original Message -
From: Andrew D. Luebke [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 28, 2003 2:16 PM
Subject: [PHP-DB] MySQL Date insert
Hello,
I have the following PHP code:
$date = date(Y-m-d H:i:s);
$result = mysql_query
From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED]
I actually think I know part of this answer... I don't think you
need to define a variable to insert into your date field. Inserting an
empty value into this filed will populate the field in the database with
the
current time, which it appears
John, thanks, now I feel stupid, it's always the silly little things that
get you. You were right, when I added the date to the existing insert I
forgot to put the ending parentheses back in. Thanks for the help.
Andrew.
At 11:26 AM 7/28/2003, CPT John W. Holmes wrote:
From: Andrew D. Luebke
11 matches
Mail list logo