suder

//Listar
}else{

	$cols = array("Código", "Espécie", "Última Alteração");
	$campos = array('colecoes.coditem', 'especie.descesp', 'colecoes.dtalt');
	$sql = "SELECT * FROM colecoes, especie, divisao WHERE colecoes.codesp = especie.codesp AND colecoes.coddiv = divisao.coddiv AND colecoes.coddiv = '$divisao'";
	$id = "id_bot";
	$order_by = "colecoes.coditem";

	$pg = new Paginacao();
	$pg->SetEndereco('principal.php?pgarea='.$pgarea.'&divisao='.$divisao);
	$pg->SetLimite(20);
	$pg->SetSql("SELECT null FROM colecoes, especie WHERE colecoes.codesp = especie.codesp AND coddiv = '$divisao'");

		
	if (!$parametro){
		$limite = @mysql_query("$sql ORDER BY $order_by ".$pg->GetLimite());
	}else{
		$tam = @strlen($parametro) - 1;
		$param = @strtoupper(@substr($parametro, 0, 1)) . @substr($parametro, 1, $tam);
		
		$limite = @mysql_query("SELECT * FROM colecoes, especie, divisao
								WHERE colecoes.codesp = especie.codesp AND colecoes.coddiv = divisao.coddiv AND colecoes.coddiv = '$divisao' AND
									especie.descesp LIKE '%$parametro%'
								ORDER BY $order_by");
				echo mysql_error();
	}
	foreach($cols as $col_name){
		if($col_name == "Código")
			$colunas .= '<td class="topo_tabela" width="10%">'.$col_name.'</td>';
		else
			$colunas .= '<td class="topo_tabela">'.$col_name.'</td>';
	}