Order By ordering wrong

jwman · #1 (**permalink**) 01-07-06, 12:41

Heres the problem when I order certain information from my database for example:

Number: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11

It would echo when called with PHP as:
1, 10, 11, 2, 3, 4, 5, 6, 7, 8, 9

I can see why it does this but is there a way so it will echo in a chronological order the PHP I am using is:

PHP Code:


			
$getnums = ("SELECT * FROM my_table WHERE var = '1' ORDER BY number ASC");

while ($row = mysql_fetch_array[$getnums]){

$numbersindb = $row['number'];

echo $numbersindb;

jwman · #2 (**permalink**) 01-07-06, 12:56

opps, sorry...The table structure was varchar and needed to be INT to order numerically...how stupid >.<

Internet Services

Web Development

Digital Marketing

Consumer Tech