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? Link to comment https://forums.phpfreaks.com/topic/93166-phpmyadmin-question/ 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. Link to comment https://forums.phpfreaks.com/topic/93166-phpmyadmin-question/#findComment-477334 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. Link to comment https://forums.phpfreaks.com/topic/93166-phpmyadmin-question/#findComment-477416 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.