สวัสดีครับ

ขอคำแนะนำด้วยครับ ผมกำลังเขียนการแสดงข้อมูลเป็นหน้าๆ หน้าละ 10 ข้อมูล แล้วด้านล่างมีเลขหน้าอยู่ด้วย ซึ่งโปรแกรมที่เขียนเป็นดังนี้ครับ

<meta http-equiv="Content-Type"  content="text/html; charset=tis-620"> 
<center>
<? 

$pagelen = 10 ;
$page = $_REQUEST['page'];
if (empty($page)) { $page=1; }

$link=mysql_connect("localhost","root","");
 if(!$link)
 {
  print("Error");
 }
 else
 {
 mysql_select_db("company",$link);
  $sql = "SELECT company, country, email1 FROM company WHERE agri=1 order by company asc";
  $res=mysql_query($sql,$link);
  $num_rows = mysql_num_rows($res); 

  $totalpage = ceil($num_rows / $pagelen);

  $goto = ($page-1) * $pagelen; 
  $sql = "SELECT company, country, email1 FROM company WHERE agri=1 order by company asc LIMIT $goto , $pagelen ";
  $res = mysql_query( $sql,$link );
  $num_rows = mysql_num_rows($res); 

  echo"<table border=1 cellpadding=3 cellspacing=0>";
  echo"<tr><td><font color='#8B0000' face='verdana' size='1'><center><b>Company</b></center></font></td>";
  echo"<td><font color='#8B0000' face='verdana' size='1'><center><b>Country</b></center></font></td>";
  echo"<td><font color='#8B0000' face='verdana' size='1'><center><b>Email</b></center></font></td></tr>";

  For ($i=0; $i < $num_rows; $i++)  { 
 $fetcharr = mysql_fetch_array($res);
 $company = $fetcharr['company'];
 $country = $fetcharr['country'];
 $email1 = $fetcharr['email1'];
 echo "<tr><td>$company</td><td>$country</td><td>$email1</td></tr>";
  echo"<tr><td><font color='#8B0000' face='verdana' size='1'>$company</font></td>";
  echo"<td><font color='#8B0000' face='verdana' size='1'>$country</font></td>";
 echo"<td><font color='#8B0000' face='verdana' size='1'>$email1</font></td></tr>";
 } 
 echo "</table>";

if ($page > 1) {
 $back = $page - 1;
 echo "<a href=$PHP_SELF?page=1>".
 "<img src=first.gif border=0 align=absmiddle alt=First></a>\n";
 echo "<a href=$PHP_SELF?page=".  $back .">
 <img src=previous.gif border=0 align=absmiddle alt=Previous></a>";
}

For ($i=1 ; $i<=$totalpage ; $i++) {
 if ($i == $page ) {
  echo " [<b><font size =+1 color=#990000>$i</font></b>] \n";
 } else  {
  echo " <a href=$PHP_SELF?page=$i>$i</a> \n";
 }
}

if ($page < $totalpage) {
 $next = $page  +1;
 echo "<a href=$PHP_SELF?page=".$next.">
 <img src=next.gif border=0 align=absmiddle alt=Next></a>";
 echo " <a href=$PHP_SELF?page=".$totalpage."><img src=last.gif border=0 align=absmiddle alt=Last></a> \n";
}

?>

ปรากฎว่ามี error ดังนี้ครับ

Parse error: parse error, unexpected $end in c:\appserv\www\main\dir_agri.txt on line 79

ขอคำแนะนำด้วยครับ

อนันต์

ตัว script ไม่สามารถหา } ปิด else condition ได้ครับ ที่ถูกควรเป็น

<meta http-equiv="Content-Type"  content="text/html; charset=tis-620">
<center>
<?

$pagelen = 10 ;
$page = $_REQUEST['page'];
if (empty($page)) { $page=1; }

$link=mysql_connect("localhost","root","");
if(!$link)
{
    print("Error");
}
else
{
    mysql_select_db("company",$link);
    $sql = "SELECT company, country, email1 FROM company WHERE agri=1 order by company asc";
    $res=mysql_query($sql,$link);
    $num_rows = mysql_num_rows($res);

    $totalpage = ceil($num_rows / $pagelen);

    $goto = ($page-1) * $pagelen;
    $sql = "SELECT company, country, email1 FROM company WHERE agri=1 order by company asc LIMIT $goto , $pagelen ";
    $res = mysql_query( $sql,$link );
    $num_rows = mysql_num_rows($res);

    echo"<table border=1 cellpadding=3 cellspacing=0>";
    echo"<tr><td><font color='#8B0000' face='verdana' size='1'><center><b>Company</b></center></font></td>";
    echo"<td><font color='#8B0000' face='verdana' size='1'><center><b>Country</b></center></font></td>";
    echo"<td><font color='#8B0000' face='verdana' size='1'><center><b>Email</b></center></font></td></tr>";

    for($i=0; $i < $num_rows; $i++)  {
        $fetcharr = mysql_fetch_array($res);
        $company = $fetcharr['company'];
        $country = $fetcharr['country'];
        $email1 = $fetcharr['email1'];
        echo "<tr><td>$company</td><td>$country</td><td>$email1</td></tr>";
        echo"<tr><td><font color='#8B0000' face='verdana' size='1'>$company</font></td>";
        echo"<td><font color='#8B0000' face='verdana' size='1'>$country</font></td>";
        echo"<td><font color='#8B0000' face='verdana' size='1'>$email1</font></td></tr>";
    }
   
    echo "</table>";

    if ($page > 1) {
         $back = $page - 1;
         echo "<a href=$PHP_SELF?page=1><img src=first.gif border=0 align=absmiddle alt=First></a>\n";
         echo "<a href=$PHP_SELF?page=".  $back ."><img src=previous.gif border=0 align=absmiddle alt=Previous></a>";
    }

    for ($i=1 ; $i<=$totalpage ; $i++) {
        if ($i == $page ) {
            echo " [<b><font size =+1 color=#990000>$i</font></b>] \n";
         } else  {
            echo " <a href=$PHP_SELF?page=$i>$i</a> \n";
        }
    }

    if ($page < $totalpage) {
        $next = $page  +1;
        echo "<a href=$PHP_SELF?page=".$next."><img src=next.gif border=0 align=absmiddle alt=Next></a>";
        echo " <a href=$PHP_SELF?page=".$totalpage."><img src=last.gif border=0 align=absmiddle alt=Last></a> \n";
    }
}
?>