I agree with Martin's assessment. Took me awhile to always remember to have
the date in the correct format.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
At 07:15 PM 3/29/2012, Matijn Woudt wrote:
On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg eth...@earthlink.net wrote:
Sending again, since no response on 1st try.
Ethan
==
Dear List
I am trying to insert data into a table, with no success.
I have two tables:
mysql
I think MySQL wants the date in -M-D format, did you try changing
$Date = date('M d Y');
to
$Date = date('Y-m-d');
- Matijn
Tru dat. But mySql doesn't want the dashes embedded. The format string
should be Ymd instead.
--
PHP Database Mailing List (http://www.php.net/)
To
See below-
- Original Message - From: Ethan Rosenberg eth...@earthlink.net
Newsgroups: php.db
To: Matijn Woudt tijn...@gmail.com
Cc: php-db-lists.php.net
php-db@lists.php.net; jim.gi...@albanyhandball.com
Sent: Friday, March 30, 2012 1:00 PM
Subject: Re: [PHP-DB] search of data base
===
Martijn Jim -
Is it just the date that is the problem?
Yes.
Tru dat. But mySql doesn't want the dashes embedded. The format string
should be Ymd instead.
That's what I am doing. No luck.
Ethan
*
You're using a format with just Ymd in it (no dashes)? Can you post
Jim Giner jim.gi...@albanyhandball.com wrote in message
news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2...
===
Martijn Jim -
Is it just the date that is the problem?
Yes.
Tru dat. But mySql doesn't want the dashes embedded. The format string
should be Ymd instead.
That's
On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner jim.gi...@albanyhandball.com wrote:
Jim Giner jim.gi...@albanyhandball.com wrote in message
news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2...
===
Martijn Jim -
Is it just the date that is the problem?
Yes.
Tru dat. But mySql