Liquid Fire Posted February 26, 2008 Share Posted February 26, 2008 I have a question about phpmyadmin and want to know if anyone here know the answer. Lets say i have table with 2 entries and is is a foreign key and i setup the relation. when i go to insert i have a select will 0 - inactive 1 - active active - 1 inactive - 0 why does it list them twice and in reserve order the second time? Quote Link to comment Share on other sites More sharing options...
revraz Posted February 26, 2008 Share Posted February 26, 2008 Sounds like one table is sorting by 0 and 1, and the other is sorting by active/inactive. It's not necessarily reverse, its just the default ASC sort order. Quote Link to comment Share on other sites More sharing options...
Liquid Fire Posted February 26, 2008 Author Share Posted February 26, 2008 i mean that is one select box, have 1 list then 2 options that are blank and the the list again in a different order, that does not make sense to have the same options twice in the select when i setup a relation. 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.