MySQL ignores INSERT queries unless I specify values for every column

[Agentmanatee]

I've searched through this forum as well as some other forums, no one else seems to have had this problem. maybe somebody knows what's going on:

I got fed up with my hosting service's limiting my processor power. It was taking far too long to do stuff. So I created my own server. It's a windows machine, but I put the latest versions of Apache, mysql, and php on it. All are configured basicly to defualts besides the changes I had to make so that I could actually access the server.

On to the problem. I'll use the following simple table to descirbe.

table name : tab
fields : (name, address, city, zip)

On the site that I pay to get hosted, I could write a simple php insert to the table that didn't use all the fields:

mysql_query("INSERT INTO tab (name, zip) VALUES ('something', 'something')"); 

This would work fine. it would insert blanks into the fields address and city.

Now on my own server, It won't even do the insert when i write it like that.

I have to write the insert as

mysql_query("INSERT INTO tab (name, address, city, zip) VALUES ('something', '', 'something', '')"); 

If i don't write it like that, it just ignores the insert. I know writing it the second way works, i've tested it on smaller tables I have.

Is there a setting I can change on my server that allows for the previous method? I don't really understand why it would work on one server but not another.

Any help would be appreciated. Thanks

[Atli]

HI, and welcome to TSDN!

When you leave out a column in a INSERT statement, you must make sure that the column either accepts NULL values or that it has a default value. Auto Increment fields can also be left out safely.

MySQL should return an error if there is a problem with your query. Try printing the mysql_error() function if your query is unsuccessful. Like so:

$result = mysql_query("Insert statement here") or die(mysql_error());
 

That should show you exactly what has gone wrong with your query.

[Agentmanatee]

Thanks for the input :) Most of my fields are text fields. If I set them up to defualt to a blank, that will fix it? I'll do the error statement printout as well. Maybe that'll shed some light on the subject.

[pbmods]

Heya, Agentmanatee.

Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

Changed thread title to better describe the problem (did you know that threads whose titles that do not follow the Posting Guidelines actually get FEWER responses?).

[Agentmanatee]

My bad, I read the read this before you post thread, didn't even see the nice little box on the side. Thank you for the help.