Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
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

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Ethan Rosenberg
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

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
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

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Ethan Rosenberg
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

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
=== 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

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
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

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Matijn Woudt
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

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Lars Nielsen
fre, 30 03 2012 kl. 20:00 +0200, skrev Matijn Woudt: 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

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Gavin
|DATE| http://dev.mysql.com/doc/refman/5.5/en/datetime.html = MySQL permits some keywords to be used as unquoted identifiers because many people previously used them. Examples are those in the following list: * |ACTION| * |BIT|