SelectLimit($query_rs_noticias, $maxRows_rs_noticias, $startRow_rs_noticias) or die($ewt->ErrorMsg());
if (isset($HTTP_GET_VARS['totalRows_rs_noticias'])) {
$totalRows_rs_noticias = $HTTP_GET_VARS['totalRows_rs_noticias'];
} else {
$all_rs_noticias = $ewt->SelectLimit($query_rs_noticias) or die($ewt->ErrorMsg());
$totalRows_rs_noticias = $all_rs_noticias->RecordCount();
}
$totalPages_rs_noticias = (int)(($totalRows_rs_noticias-1)/$maxRows_rs_noticias);
// end Recordset
// begin Recordset
$maxRows_rs_destaques = 4;
$pageNum_rs_destaques = 0;
if (isset($HTTP_GET_VARS['pageNum_rs_destaques'])) {
$pageNum_rs_destaques = $HTTP_GET_VARS['pageNum_rs_destaques'];
}
$startRow_rs_destaques = $pageNum_rs_destaques * $maxRows_rs_destaques;
$query_rs_destaques = "select cod_imovel, des_codigo, des_tipo, des_bairro, num_dormitorios,
num_area, num_valor_inicial, num_valor_final, ig_dta_entrega, ig_des_box_simples, ig_des_box_duplo, d.des_situacao_imovel
from tb_imoveis a, tb_tipos_imoveis b, tb_bairros c, tb_situacao_imovel d
where
ind_destaque = 1
and a.cod_status_imovel = 1
and a.cod_tipo = b.cod_tipo
and a.cod_bairro = c.cod_bairro
and a.ig_cod_situacao = d.cod_situacao_imovel
order by RAND()";
$rs_destaques = $ewt->SelectLimit($query_rs_destaques, $maxRows_rs_destaques, $startRow_rs_destaques) or die($ewt->ErrorMsg());
if (isset($HTTP_GET_VARS['totalRows_rs_destaques'])) {
$totalRows_rs_destaques = $HTTP_GET_VARS['totalRows_rs_destaques'];
} else {
$all_rs_destaques = $ewt->SelectLimit($query_rs_destaques) or die($ewt->ErrorMsg());
$totalRows_rs_destaques = $all_rs_destaques->RecordCount();
}
$totalPages_rs_destaques = (int)(($totalRows_rs_destaques-1)/$maxRows_rs_destaques);
// end Recordset
// begin Recordset
$query_rs_destaqueSemana ="select *
from tb_destaques
where ind_atual=1
order by cod_destaque DESC";
$rs_destaqueSemana = $ewt->SelectLimit($query_rs_destaqueSemana) or die($ewt->ErrorMsg());
$totalRows_rs_destaqueSemana = $rs_destaqueSemana->RecordCount();
// end Recordset
?>
Sala de Imóveis - Apartamentos, Casas e Imóveis à venda em Caxias do Sul
SelectLimit($query_rs_animacao) or die($ewt->ErrorMsg());
$totalRows_rs_animacao = $rs_animacao->RecordCount();
// end Recordset
?>
