[SOLVED] ORDER BY problem.
Posted: Wed Feb 16, 2005 6:53 pm
Im using the line in my code but for some reason, its only sorting the numbers in my databse by there first number.
eg;
My Code:
Shows:
142233
152
17
2342
210
24
35
486
42
How do i get it to sort in numerical order? (eg; 17, 24, 35, 42, ect...)
Code: Select all
ORDER BYeg;
My Code:
Code: Select all
$sql = "SELECT * FROM top_mybb_sites WHERE approved = 1 ORDER BY posts ASC";142233
152
17
2342
210
24
35
486
42
How do i get it to sort in numerical order? (eg; 17, 24, 35, 42, ect...)