[PHP/Mysql] Ascending values...

[Erlend]

Hello everyone, well im creating a database of "southpark" episodes & seasons

and i have made the sql query by ascending so episode 1 comes first then 2 etc.

but when i get to 10 it will be like this:

• 1
• 10
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9

Is there any way i can fix this?

 

[Tyler]

Because 10 includes 1.
if you added 11,12,13 it'd be like this
1
10
11
12
2
3
4
5
6
7
8
9

Not sure how to fix.

 

[Erlend]

Ye, i know because of the 1 ;P

 

[Superfun]

mysql eh?

select something from table order by id

 

[EliteGM]

SELECT `anything` FROM `table` ORDER BY `id` ASC

 

[Erlend]

But i don't want it to order by id, query:

SELECT * FROM spdb WHERE ssd ='1' ORDER BY epd ASC

ssd: Season Number
epd: Episode Number

 

[EliteGM]

is EPD an integer value?

 

[Erlend]

Of course

 

[EliteGM]

I'm asking if he set it as int in the DB, not as varchar or something.

 

[Erlend]

Oh, its varchar.. should i change to integer?

 

[EliteGM]

Yes That'll probably help.

 

[Erlend]

Oh thanks it worked