[SOLVED] ORDER BY problem!! help.

[newb]

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?

 

[rhodesa]

The best thing to do is make your userid column an INTEGER, as it is most likely a VARCHAR right now.

[newb]

yea ur right, thx