[RESOLVED] Insert Query: runs but inserts null for all fields

[mrgrammar]

I've never seen this before. I have a query that is created from a form input.

INSERT INTO datatable (id, sent, date, changedate, sender, age, senderemail, function, firstname, lastname, title, organization, address1, address2, city, state, zip, country, phone, fax, email, lists, site, url, size, whendoing, pricerange, goal, type, description, comments) VALUES ('1564946974', '0', '2012-08-27', '2012-08-27', 'fullname', '25+', '[e-mail]', 'org function', 'Brian', 'Durfee', 'title', 'org', 'add1', 'add2', 'city', 'state', 'zip', 'USA', '1234567890', '1234567890', '[e-mail]', '37', 'TFN', 'www.testingtesting.com', '301-400 people', 'Fall', '$16-$25', '$501-$1,000', 'pizza', 'School, High School, Clubs', 'these are my comments');

When the form submits, it connects to the database and runs the query successfully. However, all the fields in the database are NULL.

After seeing this happen, I echoed the query and got the above statement. I then ran it manually in phpMyAdmin and everything inserted correctly.

Any ideas why this is happening and what I'm doing wrong? I've not seen this before.

As a side note: There are four other queries that run when the form is submitted. Two are select queries and two are inserts. All four of these queries run perfectly. It's only the one above that I'm having a problem with.

[mrgrammar]

I found the problem. I knew it had to be something simple. It was a conflict with another query that ran an update on the record.

[Asher_ross]

Hi, Please check your other define d queries to find out the problem because above define query works up to the mark to insert a new tuple in the database defined by you.