i made this code

to get the file names and order it by hits

but i get order like that

15
2
25
3
31

i want it to be like

2
3
15
25
31

what's wrong??

looks like the column hits is defined as VARCHAR (or CHAR). You should change that to a numeric datatype (e.g. INTEGER)

would that effect with the script?

Looks like the field hits is a character field and it's ordering things alphabetically. You can either rebuild the table with that field set to int (the proper way) or you could try either :

Code:

select * from file order by cast( hits as signed);
select * from file order by hits + 0;

You could use the following to see how you've defined the table :

Code:

show create table file;

Mike

PS I must of been slow typing, didn't realise someone else had answered

thank you guys

i changed it to int(255) and now working fine i hope it doesn't affect with the script

i really appreciate it