الموضوع: ارجو مساعدة في تعدد صفحات

سلام عليكم اخواني تعبت من تعدد صفحات يعرض لي تحت صفحات بس استعلامات زي ماهي حطيت ثلاث استعلامات بصفحة فقط بس نفس حكاية يطلع لي عشين استعلام وتحت مكتوب صفحات 1 23 :

كود:

<?php 

include ("lon.php"); 


$text = array( 
'<img src="./images/a.gif" width="16" height="16">', 
'<img src="./images/a.gif" width="16" height="16">', 
'<img src="./images/a.gif" width="16" height="16">', 
'<img src="./images/a.gif" width="16" height="16">', 
'<img src="./images/a.gif" width="16" height="16">', 
'<img src="./images/a.gif" width="16" height="16">',); 

$body = array( 
'(:', 
':)', 
':|', 
'*:', 
':&', 
':+',); 

$msg_of = str_replace($body,$text,$msg_of); 


$query = "SELECT * FROM shoutbox"; 

$relst = mysql_query($query); 
while ($ro=mysql_fetch_array($relst)){ 
?> 
<center> 
  <table border='1' cellpadding='0' cellspacing='0' style='border-collapse: collapse' id='AutoNumber1' height='95' width="499"> 
    <tr> 
      <td width='497' style='border-style: solid; border-width: 1' height='24' align='center' colspan="4" bgcolor="#F5F5F5"> 
      &nbsp;</td> 
    </tr> 
    <tr> 
      <td width='36' style='border-style: solid; border-width: 1' height='18' align='center' bgcolor="#F5F5F5"> 
      <font face='Tahoma' style="font-size: 9pt; font-weight:700"><?=(email_of)?><span lang="en-us"> 
      :</span></font></td> 
      <td width='244' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18'> 
      <p align='center'> 
      <?=$ro['email_of']?></td> 
      <td width='57' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18' bgcolor="#F5F5F5"> 
      <p align="center"><font face="Tahoma"> 
      <span style="font-size: 9pt; font-weight:700"><?=(user_of)?><span lang="en-us"> :</span></span></font></td> 
      <td width='151' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18'> 
      <p align="center"> 
      <?=$ro['user_of']?></td> 
    </tr> 
    <tr> 
      <td width='36' style='border-style: solid; border-width: 1' height='18' align='center' bgcolor="#F5F5F5"> 
      <font face="Tahoma" style="font-size: 9pt; font-weight:700"><?=(site_of)?><span lang="en-us"> 
      :</span></font></td> 
      <td width='244' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18'> 
      <p align="center"> 
      <?=$ro['site_of']?></td> 
      <td width='67' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18' bgcolor="#F5F5F5"> 
      <p align="center"><b><font face="Tahoma"> 
      <span style="font-size: 9pt">&nbsp;</span><span style="font-size: 9pt" lang="en-us">Ip 
        :</span></font></b></td> 
      <td width='151' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18'> 
      <p align="center"> 
      4</td> 
    </tr> 
    <tr> 
      <td width='497' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-top-style:solid; border-top-width:1' height='25' align='center' bgcolor="#F5F5F5" colspan="4"> 
      <?=(msg_of)?></td> 
    </tr> 
    <tr> 
      <td width='36' style='border-style: solid; border-width: 1' height='25' align='center' bgcolor="#F5F5F5"> 
      &nbsp;</td> 
      <td width='461' style='border-style: solid; border-width: 1' height='25' colspan="3"> 
      <p align='center'><?=$ro['msg_of']?></td> 

  </table> 
  </center> 
  </div> 
<p align='center'>  ============== 
  <br> 
<? 
} 


&Ccedil;&aacute;&Otilde;&Yacute;&aelig;&Yacute; &Ccedil;&aacute;&Ecirc;&iacute; &Ecirc;&aelig;&Iuml; &Aring;&Ugrave;&aring;&Ccedil;&Ntilde;&aring;&Ccedil; &Yacute;&iacute; &szlig;&aacute; &Otilde;&Yacute;&Iacute;&Eacute; .. 
$limit = 2; 

$result = mysql_query("select * from shoutbox"); 
// &Uacute;&Iuml;&Iuml; &Ccedil;&aacute;&Otilde;&Yacute;&aelig;&aacute; &Yacute;&iacute; &Ccedil;&aacute;&Igrave;&Iuml;&aelig;&aacute; .. 
$numrows = mysql_num_rows($result); 

if (empty($offset)) {   $offset = 0;   } 

// $limit , $offset &Ccedil;&aacute;&Ccedil;&Icirc;&Ecirc;&iacute;&Ccedil;&Ntilde; &atilde;&auml; &Ccedil;&aacute;&Igrave;&Iuml;&aelig;&aacute; &Ccedil;&Uacute;&Ecirc;&atilde;&Ccedil;&Iuml;&Ccedil;&eth; &Uacute;&aacute;&igrave; &atilde;&Ecirc;&Ucirc;&iacute;&Ntilde;&iacute;&auml; &aring;&atilde;&Ccedil; 
$result = mysql_query("select * "." from shoutbox "." limit $offset,$limit"); 

echo "<table width=90% dir=rtl align=center cellspacing=1 cellpadding=1 border=1>"; 

while($row = mysql_fetch_array($result)) { 
$id = $row["id"]; 
$title = $row["title"]; 
echo "<tr><td><font size=2><center>$id</td></tr>"; 
echo "<tr><td><font size=2><center>$title</td></tr>"; 
} 
echo "</table>"; 

echo "<table width=90% dir=rtl align=center cellspacing=1 cellpadding=1 border=1>"; 
echo "<tr><td><font size=2><center>"; 

if ($offset >= 1) { 
$prevoffset = $offset - $limit; 
print "<a href=\"$PHP_SELF?offset=$prevoffset\">&Ccedil;&aacute;&Oacute;&Uuml;&Ccedil;&Egrave;&THORN;</a>&nbsp;\n"; 
} 

$pages=intval($numrows/$limit); 

if ($numrows%$limit) { 
   $pages++; 
} 



for ($i = 1; $i <= $pages; $i++) { 
$newoffset = $limit*($i-1); 
if ($newoffset == $offset) { 
print "<font size=2><b>$i</b></font>&nbsp;\n"; 
} else { 
print "<a href=\"$PHP_SELF?offset=$newoffset\">$i</a>&nbsp;\n"; 
} 
} 

if (! ( ($offset/$limit) == ($pages - 1) ) && ($pages != 1) ) { 
$newoffset = $offset+$limit; 
print "<a href=\"$PHP_SELF?offset=$newoffset\">&Ccedil;&aacute;&Ecirc;&Uuml;&Ccedil;&aacute;&iacute;</a>\n"; 

} 
echo "</td></tr></table>"; 

?>

للرفع

يا اخوان كود صحيح بس ماينقلني صفحة ثاني بس يكتب لي تحت صفحات 1 و 2 و 3 جربت اكواد كثيرة نفس شي كيف اخليه اذا تعدا اكثر من استعلامين او ثلاثه ؟