Row Data Insertion

[madcrazy1]

I have a table with a row for name and a row for number. Specific number belongs to specific name (eg.. telephone number)

I have table set for utf8_general_ci

I have a primary key auto_increment=1

I define two rows as UNIQUE name,number

data is inserted FROM XML node

The trouble is that after insert, I see all names and numbers inserted except that the numbers were inserted sequentially (values low to high) with respect to the primary key's values (low to high) erroneously mixing the name, number pairs. Any ideas? I need the data inserted in "document form" (order as they are reported/sent to query) Thank you.

[fenway]

If you want an order, store a sortorder value.

[madcrazy1]

I am familiar with sort order on querying a database but am not familiar with how to store it in a particlar order.

[fenway]

Don't you mean 2 columns, not 2 rows?