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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
newb Posted May 5, 2008 Author Share Posted May 5, 2008 yea ur right, thx 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.