Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Ola, estou usando uma classe para conectar ao mysql.
E estou fazendo uma consulta que retorna dentro de uma paginação. So que:
Eu não entendi o porque ele não aceita a syntax LIMIT $inicio,$max.
Aparece este erro:
Ocorreu um erro ao executar a Query SQL abaixo:
select * from clientes ORDER BY id LIMIT -3,3<
MySQL Retornou: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-3,3' at line 1
Este é meu script:
<?php
require "includes/mysql.php";if ( Registry::isRegistered( 'dbcli' ) ){
if (!isset($_GET["pagina"])) {
$pagina = 1;
}$pagina = $_GET["pagina"];
}
$max=3;
$inicio = $pagina - 1;
$inicio = $max * $inicio;
$sql = Registry::get( 'dbcli' )->sql("SELECT * FROM clientes ORDER BY id");
$total=mysql_num_rows($sql);
if ($total == 0)
echo "Nenhum registro encontrado!";{
$sql2 = Registry::get( 'dbcli' )->sql("select * from clientes ORDER BY id LIMIT $inicio,$max");
$total2=mysql_num_rows($sql2);
?>
<style type="text/css">font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}color: #0099FF;
}color: #0099FF;
}color: #99CC00;
}color: #0099FF;
}</style>
<?php while ($mostra=mysql_fetch_array($sql2)){
echo "
<table width='663' border='0' align='left' cellpadding='0' cellspacing='0'>
<tr>
<td><form action='?acao=atualizar_devedor&id_historico=$DEVCOD_devedor' method='post' name='formatualiza' id='formatualiza'>
<table width='663' border='0' cellspacing='0' cellpadding='2'>
<tr>
<td width='63'><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Nome:</font></div></td>
<td width='378'><div align='left'>
<input name='responsavel' type='text' class='inputs' id='responsavel' value='".$mostra ['responsavel']."' size='30' style='font-size:13px'>
</div></td>
<td width='56'><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>CODIGOº:</font></div></td>
<td width='150'><input name='numero1' type='text' disabled class='inputs' id='numero1' value='".$mostra ['codigo']."' size='25' style='font-size:13px'/></td>
</tr>
<tr>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>CPF:</font></div></td>
<td><div align='left'>
<input name='cpf' type='text' class='inputs' id='cpf' value='".$mostra ['cpf']."' size='20' style='font-size:13px'>
</div></td>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>RG:</font></div></td>
<td><input name='rg1' type='text' class='inputs' id='rg1' value='".$mostra ['rg']."' size='25' style='font-size:13px'/></td>
</tr>
<tr>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>CNPJ:</font></div></td>
<td><div align='left'>
<input name='cnpj' type='text' class='inputs' id='cnpj' value='".$mostra ['cnpj']."' size='20' style='font-size:13px'>
</div></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Endereço:</font></div></td>
<td><div align='left'>
<input name='endereco' type='text' class='inputs' id='endereco' value='".$mostra ['endereco']."' size='25' style='font-size:13px'>
<input name='numero' type='text' class='inputs' id='numero' value='".$mostra ['numero']."' size='8' style='font-size:13px'>
</div></td>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Plano:</font></div></td>
<td><input name='pasta1' type='text' class='inputs' id='pasta1' value='".$mostra ['plano']."' size='25' style='font-size:13px'/></td>
</tr>
<tr>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Complemento:</font></div></td>
<td><div align='left'>
<input name='bairro2' type='text' class='inputs' id='bairro2' value='".$mostra ['complemento']."' size='10' style='font-size:13px'>
</div></td>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Dominio:</font></div></td>
<td><input name='situacao2' type='text' class='inputs' id='situacao2' value='".$mostra ['dominio']."' size='25' style='font-size:13px'/></td>
</tr>
<tr>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Bairro:</font></div></td>
<td><div align='left'>
<input name='bairro' type='text' class='inputs' id='bairro' value='".$mostra ['bairro']."' size='10' style='font-size:13px'>
</div></td>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>E-mail:</font></div></td>
<td><input name='situacao1' type='text' class='inputs' id='situacao1' value='".$mostra ['email']."' size='25' style='font-size:13px'/></td>
</tr>
<tr>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>CEP:</font></div></td>
<td><div align='left'>
<input name='cep2' type='text' class='inputs' id='cep5' value='".$mostra ['cep']."' size='10' style='font-size:13px'>
</div></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Cidade:</font></div></td>
<td><div align='left'>
<input name='cidade1' type='text' class='inputs' id='cidade1' value='".$mostra ['cidade']."' size='20' style='font-size:13px'>
</div></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Estado:</font></div></td>
<td><div align='left'>
<input name='estado1' type='text' class='inputs' id='estado1' value='".$mostra ['estado']."'style='font-size:13px'size='5'>
</div></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Telefone:</font></div></td>
<td><label></label>
<div align='left'>
<input name='ddd1' type='text' class='inputs' id='ddd1' value='$DDD1_devedor' size='1' style='font-size:13px'>
<input name='tel1' type='text' class='inputs' id='tel1' value='".$mostra ['data']."' size='10' style='font-size:13px'/>
<br>
</div></td>
</tr>
<tr>
<td> </td>
<td><input type='submit' name='Submit' value='Atualizar dados' class='botao' /></td>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Telefone:</font></div></td>
<td>
<label> </label>
<label></label>
<label></label>
<div align='left'>
<input name='2ddd' type='text' class='inputs' id='2ddd' value='$DDD2_devedor' size='1' style='font-size:13px'>
<input name='fone2' type='text' class='inputs' id='fone2' value='".$mostra ['data']."' size='10' style='font-size:13px'/>
<br>
</div></td>
</tr>
<tr>
<td> </td>
<td><label></label></td>
<td><div align='right'><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>Telefone:</font></div></td>
<td>
<label> </label>
<label></label>
<label></label>
<div align='left'>
<input name='3ddd' type='text' class='inputs' id='3ddd' value='$DDD3_devedor' size='1' style='font-size:13px'>
<input name='fone3' type='text' class='inputs' id='fone3' value='".$mostra ['data']."' size='10' style='font-size:13px'/>
<br>
</div></td>
</tr>
</table>
</form></td>
</tr>
</table>
";
}?>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="71" scope="col">
<div align="center">
<?php
}$mais = $pagina + 1;
$pgs = ceil($total / $max);
if($pgs > 1 )if($menos >0)
echo "<a href=\"?area=devedores&pagina=$menos\" class='texto_paginacao'>Anterior</a> ";if (($pagina-4) < 1 )
$anterior = 1;
else
$anterior = $pagina-10;
if (($pagina+4) > $pgs )
$posterior = $pgs;
else
$posterior = $pagina + 10;
for($i=$anterior;$i <= $posterior; $i++)
if($i != $pagina)
echo " <a href=\"?area=devedores&pagina=".($i)."\" class='texto_paginacao'>$i</a>";else
echo " <strong class='texto_paginacao_pgatual'>[$i]</strong>";
if($mais <= $pgs)
echo " <a href=\"?area=devedores&pagina=$mais\" class='texto_paginacao'>Proxima</a>";
}
}
?>
</div></td>
</tr>
</table>Carregando comentários...