[SOLVED] Does field order matter???

[jwwceo]

I jsut posted a few minutes ago with a syntax error was getting. Now, when I insert the query, it works, but only about 2/3rds of my fields insert. The others don't. Does the order that I list the fields in my INSERT query, have to be same as the field order in the database??

 

This is seriously all I can think of. The data looks identical, but some is being inserted and some isn't. The last 1/3 just stays blank.

 

JW

[revraz]

You want to make sure you define what columns they go in and not the order they appear.

 

So always specify

 

INSERT INTO table (column1, column2, column3) VALUES ('$data1', '$data2', '$data3');

 

This will insert $data1 into column1, and so on.