SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
-
Nov 28, 2003, 22:07 #1
- Join Date
- Aug 2003
- Location
- Brasil
- Posts
- 82
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Help on numbering the pages of a query result!
I would like a little help here in what is wrong with my sintax? I need to print the number of pages of a query result linked to the respective results take a look:
PHP Code:if(!isset($comeco)){
$comeco = "0"
}
$inscritos = mysql_query(SELECT COUNT(Alunos_ID) FROM Curso_Potensal_Alunos) ;
$paginas = "$inscritos/30"; I need to round this number UP
while($paginas >= $pagnumero){
pagnumero++;
if($comeco == "0"){
echo("<font face=verdana color=black size=2><a href=\"" . $PHP_SELF . "?comeco=" . ($pagnumero*$comeco)> $pagnumero </a></font>");
}
else{
echo("<font face=verdana color=black size=2><a href=\"" . $PHP_SELF . "?comeco=" . (($pagnumero*30)-1)> $pagnumero </a></font>");
}
}
$sql = "SELECT Alunos_ID, Alunos_Nome, Alunos_Email, Alunos_Instituicao, Alunos_Registro FROM Curso_Potensal_Alunos LIMIT" . $comeco . ",30";
$info = mysql_query($sql);
while($infor = mysql_fetch_array($info)){
$id = $infor["Alunos_ID"];
$aluno = $infor["Alunos_Nome"];
$email = $infor["Alunos_Email"];
$instituicao = $infor["Alunos_Instituicao"];
$registro_academico = $infor["Alunos_Registro"];
echo("<font face=verdana size=1 color=black>$aluno</font>\n");
echo("<font face=verdana size=1 color=black>$email</font>\n");
echo("<font face=verdana size=1 color=black>$instituicao</font>\n");
echo("<font face=verdana size=1 color=black>$registro_academico</font>\n");
echo("<font face=verdana size=1 color=black><a href='aluno_mais.php?id=$id'>+ info</a></font>\n");
}
***: Joao Gabriel Branco
-
Nov 29, 2003, 04:34 #2
- Join Date
- Nov 2003
- Location
- Arnhem, The Netherlands
- Posts
- 75
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
The next line does not look ok:
PHP Code:echo("<font face=verdana color=black size=2><a href=\"" . $PHP_SELF . "?comeco=" . ($pagnumero*$comeco)> $pagnumero </a></font>");
PHP Code:$temp = $pagnumero*$comeco;
echo("<font face=verdana color=black size=2><a href=\"".$PHP_SELF."?comeco=".$temp.">$pagnumero</a></font>");
Bookmarks