[SOLVED] Order by Problem

[Ryuujin]

$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?

[sspoke]

ORDER By seaon, episode DESC

 

i think.

 

ASC/DESC function should be used somewhere.

[Ryuujin]

No, that reverses its order...

I want it to make the 10 in the correct place.

[fenway]

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.