hai i have a problem with my coding...
i want to show the number of the field that have in my database..
the problem here is i use the next page / previous page coding....
for example in page 1 it start with 1-5..
so that if i click next page it begin with 6...
and so on...
my problem is when i click next page i always start with number 1...
so can u help me to solve my problem...
below is my current coding...
<?
include 'dbase.php';
$query = "SELECT * FROM sekolah";
$result = mysql_db_query($dbname,$query);
while($row = mysql_fetch_array($result)) {
$Nama_Sekolah = $row["Nama_Sekolah"];
$Alamat = $row["Alamat"];
$Logo = $row["Logo"];
}
?>
<?php
include 'dbase.php';
// Number of entries per page
$per_page = 5;
$sql_text = ("SELECT * from pelajar");
$result = mysql_db_query($dbname,$query);
// Set page #, if no page isspecified, assume page 1
if (!$page) {
$page = 1;
}
$prev_page = $page -1;
$next_page = $page + 1;
$query = mysql_query($sql_text);
// Set up specified page
$page_start = ($per_page * $page) - $per_page;
$num_rows = mysql_num_rows($query);
if ($num_rows <= $per_page) {
$num_pages = 1;
} else if (($num_rows % $per_page) == 0) {
$num_pages = ($num_rows / $per_page);
} else {
$num_pages = ($num_rows / $per_page) + 1;
}
$num_pages = (int) $num_pages;
if (($page > $num_pages) || ($page < 0)) {
error("You have specified an invalid page number");
}
$sql_text = $sql_text . " LIMIT $page_start, $per_page " ;
$query = mysql_query($sql_text);
$num= 1; // show the total field that have in database
while ($row = mysql_fetch_array($query)) {
$id = $row["id"];
$nama = $row["nama"];
$no_kp = $row["no_kp"];
$no_tel = $row["no_tel"];
$tingkatan = $row["tingkatan"];
$no_bilik = $row["no_bilik"];
//echo $result[nama];
?>
<tr bordercolor="#666666">
<td><div align="center" class="style24 style19"><span class="style10"><? echo ($num);?></td>
<td><div align="center" class="style24 style19"><span class="style10"> <? echo nl2br($nama); ?><br>
</span></div></td>
<td><div align="center" class="style24 style19">
<div align="center"><span class="style6"> <? echo nl2br($no_kp); ?><br>
</span></div>
</div></td>
<td class="style6"><div align="center" class="style24 style19">
<div align="center"> <? echo nl2br($no_bilik); ?><br>
</div>
</div></td>
<td class="style6"><div align="center" class="style24 style19">
<div align="center"> <? echo nl2br($tingkatan); ?><br>
</div>
</div></td>
<td class="style6"><div align="center"><span class="style21 style19"><span class="style18"><span class="style27"><span class="style24"><? echo nl2br($no_tel); ?></span></span></span></span></div></td>
<td class="style6"><div align="center" class="style21 style19">
<div align="center"><span class="style18"><a href="ubah_pelajar.php?id=<? echo $id; ?>">[Kemaskini]</a></span></div>
</div></td>
</tr>
<? $num ++;
}
?>
<?
// Previous
if ($prev_page) {
echo " <a href=\"$PHP_SELF?page=$prev_page\">Prev</a>";
}
// Page # direct links /
for ($i = 1; $i <= $num_pages; $i++) {
if ($i != $page) {
echo " <a href=\"$PHP_SELF?page=$i\">$i</a> ";
} else {
echo " $i ";
}
}
// Next
if ($page != $num_pages) {
echo "<a href=\"$PHP_SELF?page=$next_page\">Next</a>";
}
?>
