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

[مسيو روميو]

سلام عليكم اخواني تعبت من تعدد صفحات يعرض لي تحت صفحات بس استعلامات زي ماهي حطيت ثلاث استعلامات بصفحة فقط بس نفس حكاية يطلع لي عشين استعلام وتحت مكتوب صفحات 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 جربت اكواد كثيرة نفس شي كيف اخليه اذا تعدا اكثر من استعلامين او ثلاثه ؟