[PHP-DB] search of data base - again

2012-03-29 Thread Ethan Rosenberg
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> describe Visit3; ++--+--+-+-++ | Field | Type | Null | Key | Default

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

2012-03-29 Thread Matijn Woudt
On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg 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> describe Visit3; > ++--+--+-

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 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> describe Vi

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 un

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

2012-03-30 Thread Ethan Rosenberg
See below- - Original Message - From: "Ethan Rosenberg" Newsgroups: php.db To: "Matijn Woudt" Cc: "php-db-lists.php.net" ; Sent: Friday, March 30, 2012 1:00 PM Subject: Re: [PHP-DB] search of data base - again At 07:15 PM 3/29/2012, Matijn Woudt w

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"" 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 what I am d

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 wrote: > > ""Jim Giner"" 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

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 > wrote: > > > > ""Jim Giner"" wrote in message > > news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2... > >> === > >> Martijn & Jim - > >> > >> Is it just the date that is the problem? > >

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

2012-03-30 Thread Gavin
|DATE| => 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|

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

2012-03-31 Thread Gonzalo
Why don´t you echo the $sql2 to see the query. That´s would be very helpful. Also, are you closing the ')' in the 'values'? Greetings On Fri, Mar 30, 2012 at 3:55 PM, Gavin wrote: > |DATE| >