Jump to content

[SOLVED] Does field order matter???


jwwceo

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/82202-solved-does-field-order-matter/
Share on other sites

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.