Re: [nyphp-talk] inserting data into MySQL table.

2007-07-24 Thread PaulCheung
, July 23, 2007 10:13 PM Subject: Re: [nyphp-talk] inserting data into MySQL table. On 7/23/07, PaulCheung <[EMAIL PROTECTED]> wrote: Hi everybody, Thanks for the information, unfortunately for me there are no arrays being used. The names used are solely the names of each individual column/fie

Re: [nyphp-talk] inserting data into MySQL table.

2007-07-23 Thread csnyder
On 7/23/07, PaulCheung <[EMAIL PROTECTED]> wrote: Hi everybody, Thanks for the information, unfortunately for me there are no arrays being used. The names used are solely the names of each individual column/field in the table. I have already tried all the suggestions to no avail. That is why I h

Re: [nyphp-talk] inserting data into MySQL table.

2007-07-23 Thread David Krings
PaulCheung wrote: Hi everybody, Thanks for the information, unfortunately for me there are no arrays being used. The names used are solely the names of each individual column/field in the table. I have already tried all the suggestions to no avail. That is why I hardcoded a version of my inse

Re: [nyphp-talk] inserting data into MySQL table.

2007-07-23 Thread PaulCheung
uot;NYPHP Talk" Sent: Monday, July 23, 2007 7:04 PM Subject: Re: [nyphp-talk] inserting data into MySQL table. On 7/23/07, Jon Baer <[EMAIL PROTECTED]> wrote: Id guess that one of your data types (or more) is still not valid for the type declared but ~not sure if you know this~ but

Re: [nyphp-talk] inserting data into MySQL table.

2007-07-23 Thread David Krings
PaulCheung wrote: I have been having real difficulties try to insert a 20 column record into a table (using PHP not MySQL monitor). I'd echo the query before sending it to the db engine, copy and paste it into the query browser, and then see what happens. It seems as if you do not escape an

Re: [nyphp-talk] inserting data into MySQL table.

2007-07-23 Thread csnyder
On 7/23/07, Jon Baer <[EMAIL PROTECTED]> wrote: Id guess that one of your data types (or more) is still not valid for the type declared but ~not sure if you know this~ but you can add column names before your query ... INSERT INTO my_table (col1_name, col2_name) VALUES (col1_value, col2_value) /

Re: [nyphp-talk] inserting data into MySQL table.

2007-07-23 Thread Jon Baer
Id guess that one of your data types (or more) is still not valid for the type declared but ~not sure if you know this~ but you can add column names before your query ... INSERT INTO my_table (col1_name, col2_name) VALUES (col1_value, col2_value) // Try a few values up until you error out

[nyphp-talk] inserting data into MySQL table.

2007-07-23 Thread PaulCheung
I have been having real difficulties try to insert a 20 column record into a table (using PHP not MySQL monitor). If I hardcode I can add a record .Taking the script that works I then doctor it substituting the hardcoding with $_POST values and then fall over (meaning no record is written). I kn