[RESOLVED] Order By method

[Rodrigo_Z]

I created a website and I order the php display at the page by the id in Desc order, but when I enter an ID bigger than 100 it goes to the end of the page not to the top, as the screenshot´s:

Why it don´t order correctly? The 102 is not on the top?

Thanks!

[Piranha]

My guess would be that you treat it like a string, and then 102 comes before 15. Show some code, otherwise it is not possible to help you out further.

[Rodrigo_Z]

Ok, it´s a simple sql query:

$link = mysql_connect("$DBServer","$DBUser", "$DBPass");
			mysql_select_db("$DSN");
			$sql_usadas = mysql_query("SELECT * FROM scm_barcos_usados ORDER BY tamanho DESC",$link)or die("Morreu ao consultar a tabela de barcos usados!");
			$contagem = mysql_num_rows($sql_usadas);
				if($contagem) {
						while($row_usadas = mysql_fetch_array($sql_usadas)) {
					$status = $row_usadas['barcostatus'];
					$barcouId = $row_usadas['barcouId'];
					$fotoId = $row_usadas['fotoId'];

Thans these variables are printed.

Thanks!

[Rodrigo_Z]

Thanks it solved!

Database ans Integer!