session_start(); include "../includes/include_configuracao.php"; include "../includes/include_verifica_usuario.php"; include "../includes/include_conexao.php"; include "../includes/include_cabecalho.php"; include "../includes/include_funcoes.php"; include "ini.php"; $regsporpag = $registros_pagina; $pagina = $_GET["pagina"]; $ordem = $_GET["ordem"]; $sentido = $_GET["sentido"]; $palavrachave = $_GET["palavrachave"]; if ($pagina == "") {$pagina = "1";} if ($ordem == "") {$ordem = "Rep_Nome";} if ($sentido == "") {$sentido = "desc";} $inicio = (intval($pagina) * $regsporpag) - $regsporpag; $sql = "select Cod_Representante, Rep_Nome, Rep_Endereco, Rep_Telefone, Rep_Email from vendas where 0 = 0 "; if ($palavrachave != "") { $sql .= "and (Rep_Nome like '%".$palavrachave."%' or Rep_Email like '%".$palavrachave."%' or Rep_Endereco like '%".$palavrachave."%' or Rep_Telefone like '%".$palavrachave."%') "; } $rs_total = mysql_query($sql); $total_registros = mysql_num_rows($rs_total); $sql .= " order by ".$ordem." ".$sentido." limit ".$inicio.",".$regsporpag; $rs_rep = mysql_query($sql); $total_paginas = ceil($total_registros / $regsporpag); if ($total_paginas == 0) {$total_paginas = 1;} ?>
|
||||||||||||||||||