newb Posted May 5, 2008 Share Posted May 5, 2008 k usually i would be able to fix something like this, but its not as simple as it seems... mysql_query("SELECT * FROM cms_table WHERE id='$_GET[id]' ORDER BY userid ASC"); that is my php code im having problem with. the problem is that i want the order to go like this: 1 2 3 4 5 6 7 8 9 10 but its going like this instead: 1 10 11 12 13 2 20 21 22 3 4 5 6 7 8 9 how do i fix that? Link to comment https://forums.phpfreaks.com/topic/104200-solved-order-by-problem-help/ Share on other sites More sharing options...
rhodesa Posted May 5, 2008 Share Posted May 5, 2008 The best thing to do is make your userid column an INTEGER, as it is most likely a VARCHAR right now. Link to comment https://forums.phpfreaks.com/topic/104200-solved-order-by-problem-help/#findComment-533427 Share on other sites More sharing options...
newb Posted May 5, 2008 Author Share Posted May 5, 2008 yea ur right, thx Link to comment https://forums.phpfreaks.com/topic/104200-solved-order-by-problem-help/#findComment-533428 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.