PHP - Identifying The Same Current Page With A Number Of Pages

hi guy's i have on one page select from table, and i don't know how to limit showing content from database on 3, and rest to make number under it and when i click on that number next 3 is showen? Something like on forum when you have more topics then you can show, on botom of page are showen numbers (links). Can some explain me how to do this? i put in while loop something like this
Code: [Select]
while ($prom = mysql_fetch_object($res) and $i<3) and now it is limited on showing first 3, my problem is showing next 3, and if there is more how to split it on 3 per page?

<?php
  $ThreadID = $_GET['threadid'];
  If (isset($_GET['page'])) { $Page = intval($_GET['page']); }
  Elseif (isset($_POST['page'])) { $Page = intval($_POST['page']); }
  Else { $Page = 1; }
  $ThreadQry = "SELECT * FROM ".FORUM_THREADS." WHERE thread_id='{$ThreadID}'";
  $ThreadRes = mysql_query($ThreadQry, $db);
  $ThreadTitle = mysql_result($ThreadRes, 0, 'thread_title');
  $ForumID = mysql_result($ThreadRes, 0, 'forum_id');
  $Locked = mysql_result($ThreadRes, 0, 'locked');
  
  If ($Page == 1) { $Limit = 0; }
  Else { $Limit = $Page * 20; }
  $Limit2 = $Limit + 20;
  $PostsTotal = mysql_num_rows(mysql_query("SELECT * FROM ".FORUM_POSTS." WHERE thread_id='{$ThreadID}'", $db));
  $PostsQry = "SELECT * FROM ".FORUM_POSTS." WHERE thread_id='{$ThreadID}' ORDER BY  `post_id` ASC LIMIT {$Limit}, {$Limit2}";
  $PostsResult = mysql_query($PostsQry, $db);
  $PostsOnPage = mysql_num_rows($PostsResult);
  $PostCounter = 0;
  
  $PermissionQuery = "SELECT * FROM ".PERMISSIONS." WHERE forum_id='".$ForumID."'";
  $PermissionResult = mysql_query($PermissionQuery, $db);
  $PermissionPostReply = mysql_result($PermissionResult, 0, 'min_post_reply');
  $PermissionReply = intval($PermissionPostReply);
?>
<div class='tableborder'>
    <?php if ($MemLevel >= $PermissionReply) { 
        If ($Locked == 'no') {
    ?>
    <div align="right" style="background-color: #979797">
        <a href="./index.php?act=reply&threadid=<?php echo $ThreadID; ?>"><img src="./images/reply.png"></a>
    </div>
    <?php }
    Else {
        ?>
        <div align="right" style="background-color: #979797">
        <?php If ($MemLevel >= 1000) { Echo "<a href='./index.php?act=reply&threadid={$ThreadID}'>"; } ?><img src="./images/locked_reply.png"> <?php If ($MemLevel >= 1000) { Echo "</a>"; } ?><br>
    </div>
    <?php
    }
    }
    ?>
<div class='maintitle' align='left'><img src='./images/nav_m.gif' border='0' alt='' width='8' height='8'>&nbsp;<a href="./index.php?act=viewthread&threadid=<?php echo $ThreadID; ?>"><?php echo $ThreadTitle; ?></a></div>
<table width="100%" border="0" cellspacing="1" cellpadding="4">
    <tr>
        <th align="Center" width="20%" class='titlemedium'>Author</th>
        <th align="Left" width="80%" class='titlemedium'>Post</th>
    </tr>
<?php
  While ($PostCounter < $PostsOnPage) {
?>
    
<?php  
  $PostCounter++;   
  }
?>
</table>
</div>

This is what I have so far for displaying a thread in a forum. This is set to retrieve 20 Posts per page for each thread.
What I want to do is At the bottom under </table> is display a drop down box which will add a selection for each page of posts. How would I work out how many pages this drop down box needs to add?

The posts table is stored in a constant called FORUM_POSTS and they are sorted into threads by thread_id in that table.

Hello everyone,

I'm trying to code a section of the site which is like an advertising website (i.e, gumtree) where people can post an Ad on the site and have any responses sent to them via email. The thing is that I have a form where they can enter their details and need to POST the information to the following page which is a preview page of their Ad. I have the form action returning to the same page for validation but I need the $_POST vaules to populate the following page without sending information to the database (in an effort to keep the database clean should they decide not to publish their Ad.

There are 3 pages in total CREATE AD > PREVIEW AD (where they can go back and edit if they need to) > Publish AD (where they confirm terms and send to database).  I do have session variables already set after login in and a seperate table to hold the details after they have confirmed the Ad & terms.

Any ideas would be greatly appreciated.

Thanks, L-plate

Hi Everyone.

i have a page which list all records. i then have several detail pages which i need to link via the id number. for ex.

records:
id number name
1 john smith
2 peter parker

the detail page is layout out like so:
View details page 1 | view details page 2 | view details page 3

Any help would be appreciated. Thanks.

is this possibe with php?