Mysql Order BY

[lalnfl]

Lets say I have this query:

 

$sql = mysql_query("SELECT * FROM Member ORDER BY posts DESC LIMIT 10");

while ($get = mysql_fetch_array($sql)){

 

$row .= $get['id'];

$posts .= $get['posts'];

 

echo "$row - $posts<br />";

 

}

 

Lets say I have two of rows, with posts fields of 84 and 803. When it displays it, it grabs the 84 row first, when I want the bigger number 803 first. Is there a way to fix this?

[fugix]

so instead of it descending it actually ascends?

[lalnfl]

I have tried it with more numbers, and it seems to be doing something like this:

 

84

803

77

707

51

505

 

It doesn't take into account the third number on some of these.

[wildteen88]

What data type have you set your id field to when creating your table? Make sure the id column is set to INT

[lalnfl]

The id is INT, but should the posts be INT aswell? Right now it is VARCHAR.

[fugix]

yes it needs to be int unless you are planning on inserting letters.

[Pikachu2000]

VARCHAR() fields will order alphabetically, which it is doing now. That order is correct for a DESC order on a VARCHAR field.

[lalnfl]

Alrighty guys thanks! Wasn't too sure about this. Thanks for the help.