mysterious problem...

edikasim81

hello everybody...
i got a mysterious problem with my coding below..
before this thid code run properly without problem...
but this morning i ran this file page the data don't appear...
if i throw the technique pagination and show the data from table as usually it's not had a problem...but i must use pagination technique for show data from table..
plz...help me

<?php

//Set the page size
$PageSize = 10;
$StartRow = 0;

//Set the page no
if(empty($_GET['PageNo'])){
    if($StartRow == 0){
        $PageNo = $StartRow + 1;
    }
}else{
    $PageNo = $_GET['PageNo'];
    $StartRow = ($PageNo - 1) * $PageSize;
}

//Set the counter start
if($PageNo % $PageSize == 0){
    $CounterStart = $PageNo - ($PageSize - 1);
}else{
    $CounterStart = $PageNo - ($PageNo % $PageSize) + 1;
}

//Counter End
$CounterEnd = $CounterStart + ($PageSize - 1);
?> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style.css" rel="stylesheet" type="text/css">
<title>Maklumat Kakitangan</title>
</head>
<?php

include 'dbase.php';

 $query = "SELECT * FROM staffjwzh";
 $result = mysql_db_query($dbname,$query);

 $PgunaRecord = mysql_query("SELECT * FROM staffjwzh");
 $result = mysql_query("SELECT * FROM staffjwzh ORDER BY jawatan LIMIT $StartRow,$PageSize");

 //Total of record
 $RecordCount = mysql_num_rows($PgunaRecord);

 //Set Maximum Page
 $MaxPage = $RecordCount % $PageSize;
 if($RecordCount % $PageSize == 0){
    $MaxPage = $RecordCount / $PageSize;
 }else{
    $MaxPage = ceil($RecordCount / $PageSize);
 }
?>
<body>
<table width="98%" border="0" align="center" cellspacing="0" >
  <tr>
    <td valign="top"><table width="100%"  border="0" cellspacing="0" bgcolor="#FFFFFF">
      <tr>
        <td><? include 'header.php' ?></td>
      </tr>
      <tr>
        <td height="10"><? include 'date.php' ?></td>
      </tr>
      <tr>
        <td valign="top"><table width="100%"  border="0" cellspacing="0" bgcolor="#FFFFFF">
          <tr>
            <td width="16%" valign="top"><? include 'menu.php' ?></td>
            <td width="68%" valign="top"><table width="95%"  border="0" align="center" cellspacing="0">
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td class="bigusername"><div align="center"><img src="imj/warga.gif" width="598" height="100"></div></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td><div align="center" class="smallfont">Jumlah Rekod : <? echo $RecordCount ?></div></td>
                </tr>
                <td valign="top"><table width="100%"  border="1" align="center" cellpadding="4" cellspacing="1" bordercolor="#000000">
                  <tr class="vbmenu_popup">
                    <td width="6%"><div align="center" class="smallfont">BIL</div></td>
                    <td width="31%"><div align="center" class="smallfont">NAMA</div></td>
                    <td width="21%"><div align="center" class="smallfont">JAWATAN</div></td>
                    <td width="18%"><div align="center" class="smallfont">NO TELEFON </div></td>
                    <td width="24%"><div align="center" class="smallfont">E-MEL</div></td>
                  </tr>
					<? 
  					$i=1;
  					while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    				$bilangan = $i + ($PageNo-1)*$PageSize;
					$bil = $row[0]; 
					$nama = $row[1];
					$jawatan = $row[8];
					$email = $row[12];
					$notel = $row[13];

				$query2 = "SELECT * FROM jawatan 
			  				WHERE id = '$jawatan'"; 
			  	$result2 = mysql_db_query($dbname,$query2);

			  	$row2 = mysql_fetch_array($result2);

			  	$nama_jwtn = $row2["nama_jwtn"]; 

				//if ( ($i % 2) == 1 ) { $bg = "bgcolor=\"#cccccc\"";  }
				//else { $bg = "bgcolor=\"white\"";  }
		 		?>	
              <tr class="tcat">
                <td  align="center" class="smallfont"><? echo $bilangan ?></td>
                <td class="smallfont"><a href="detail_staff.php?bil=<? echo $bil ?>"><? echo $nama ?></a></td>
                <td align="center" class="smallfont"><? echo $nama_jwtn ?></td>
                <td align="center" class="smallfont"><? echo $notel ?></td>
                <td align="center" class="smallfont"><? echo $email ?></td>
              </tr>
			  <? $i++;  } ?>
            </table>
			    <table width="100%"  border="0" align="center">
                  <tr>
                    <td align="right" class="smallfont">&nbsp;</td>
                    <td align="right" class="smallfont">&nbsp;</td>
                  </tr>
                  <tr>
                    <td width="95%" align="right" class="smallfont"><strong>Muka</strong></td>
                    <td width="5%" align="right" class="smallfont"><?php
    //Print First & Previous Link is necessary
    if($CounterStart != 1){
        $PrevStart = $CounterStart - 1;

        print "<a href=\"".$_SERVER['PHP_SELF']."?PageNo=1>First </a>: ";
        print "<a href=\"".$_SERVER['PHP_SELF']."?PageNo=$PrevStart>Previous </a>";
    }
    print " [ ";
    $c = 0;

    //Print Page No
    for($c=$CounterStart;$c<=$CounterEnd;$c++){
        if($c < $MaxPage){
            if($c == $PageNo){
                if($c % $PageSize == 0){
                    print "$c ";
                }else{
                    print "$c ,";
                }
            }elseif($c % $PageSize == 0){
                echo "<a href=\"".$_SERVER['PHP_SELF']."?PageNo=$c\">$c</a> ";
            }else{
                echo "<a href=\"".$_SERVER['PHP_SELF']."?PageNo=$c\">$c</a> ,";
            }//END IF
        }else{
            if($PageNo == $MaxPage){
                print "$c ";
                break;
            }else{
                echo "<a href=\"".$_SERVER['PHP_SELF']."?PageNo=$c\">$c</a> ";
                break;
            }//END IF
        }//END IF
   }//NEXT

  echo "] ";

  if($CounterEnd < $MaxPage){
      $NextPage = $CounterEnd + 1;
      echo "<a href=\"".$_SERVER['PHP_SELF']."?PageNo=$NextPage>Next</a>";
  }

  //Print Last link if necessary
  if($CounterEnd < $MaxPage){
   $LastRec = $RecordCount % $PageSize;
    if($LastRec == 0){
        $LastStartRecord = $RecordCount - $PageSize;
    }
    else{
        $LastStartRecord = $RecordCount - $LastRec;
    }

    print " : ";
    echo "<a href=\"".$_SERVER['PHP_SELF']."?PageNo=$MaxPage>Last</a>";
    }
  ?></td>
                  </tr>
                </table>
				  <div align="center"></div></td>
		  </tr>
		</table>            
          </td>
        <td width="16%" valign="top"><? include 'menu2.php' ?></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><? include 'footer.php' ?></td>
  </tr>
</table></td>
  </tr>
</table>
</body>
</html>

paulnaj

Hi there,

' To be a good programmer...'

First off, I'd start indenting your PHP code properly.

Secondly, I would look at indenting your HTML as well. I can't see how you could possibly keep control otherwise.

Anyway, that's where the problem is (at least one of your problems - there may be others but I would fancy trying to find them as it stands) ... you're missing a '<tr>' here ...

<td><div align="center" class="smallfont">Jumlah Rekod : <? echo $RecordCount ?></div></td>
</tr>

[b]Opening <tr> missing here[/b]

<td valign="top"><table width="100%" border="1" align="center" cellpadding="4" cellspacing="1" bordercolor="#000000">

Paul 🙂