auto increament problem

[kusal]

I have two fields with auto increment, so basically the two columns will have the same ids

what I want to know is if i update/change values frequently in one column, will the two columns have same ids when inserting a new record.

[leatherback]

if you do your updates on other fields than the auto-increment, and you do not change the autoincrement next value, you should not have a problem.
However.. Why on earth would you have 2 autoincrements in the same table with the same value?

[kusal]

Lets say that I have two fields v_id and image_order
I need to have same v_id value in the image_order field also on insert

I must be able to edit the image_order so i can change the image order that is displayed later in the client side

[leatherback]

OK, makes more sense now.

I think you should OK, as mysql stores which number is next in the auto-increment, but you coul dhave a test though phpmydamin; insert 4 records, manually adjust the sotoerder colum, and insert a new record.

[lazzerous]

use a 'select insert' statament

INSERT INTO tablename ('image_order') SELECT (MAX(v_id) + 1) FROM tablename;