Ryuujin Posted September 3, 2007 Share Posted September 3, 2007 $result = mysql_query("SELECT * FROM LinkTvShows WHERE parent='$id' ORDER BY season, episode"); Ok, it orders, unless the number is '10'. How do I fix it, cause normally it goes like 1 10 2 3 4 5 6 etc. How do I get it to go: 1 2 3 4 5 6 7 8 9 10 11 etc? Link to comment https://forums.phpfreaks.com/topic/67833-solved-order-by-problem/ Share on other sites More sharing options...
sspoke Posted September 3, 2007 Share Posted September 3, 2007 ORDER By seaon, episode DESC i think. ASC/DESC function should be used somewhere. Link to comment https://forums.phpfreaks.com/topic/67833-solved-order-by-problem/#findComment-340976 Share on other sites More sharing options...
Ryuujin Posted September 3, 2007 Author Share Posted September 3, 2007 No, that reverses its order... I want it to make the 10 in the correct place. Link to comment https://forums.phpfreaks.com/topic/67833-solved-order-by-problem/#findComment-340979 Share on other sites More sharing options...
fenway Posted September 4, 2007 Share Posted September 4, 2007 Since Ryuujin doesn't want to tell us, it's field+0 ... but that probably means it should have been an INT not a CHAR field to begin with. Link to comment https://forums.phpfreaks.com/topic/67833-solved-order-by-problem/#findComment-341550 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.