madcrazy1 Posted September 4, 2011 Share Posted September 4, 2011 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 4, 2011 Share Posted September 4, 2011 If you want an order, store a sortorder value. Quote Link to comment Share on other sites More sharing options...
madcrazy1 Posted September 7, 2011 Author Share Posted September 7, 2011 I am familiar with sort order on querying a database but am not familiar with how to store it in a particlar order. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 7, 2011 Share Posted September 7, 2011 Don't you mean 2 columns, not 2 rows? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.