[Gordon Freeman]

hey

im making forums for my website but i cant figure out how to divide pages, if like 40 replys are made to a thread

i need a script which would devide pages similar to any other BB around the net... if someone could point out a tutorial i would really appreciate it


Freeman

[NeverMind]

this needs the LIMIT in your mysql_query..
like this :

PHP Code:

mysq_query("SELECT * FROM table_1 LIMIT 0, 10"); 

LIMIT a, b :
a is the record number that mysql should start fetching from ..
b is the number of records to be fetched ,,
meaning in my example : mysqk will fetch 10 records (b) starting from record zero (a)

and you can start bring the other ones by passing the number (a) in your links ..

that's an old script I made that do like this , take a good look at it :

PHP Code:

/*this where we give the link new value .. thanks to spaceman-Spiff*/

        if (is_numeric($_GET['start_row'])) {

           $start_row = $_GET['start_row'];

                     } else {

           $start_row = 0;

                     }



/*copy varibale value to use it in the previous link*/

$start_row2= $start_row;



/*submit MySQL query and recive info from it*/

        $result=mysql_query("SELECT * FROM books ORDER BY title LIMIT $start_row ,10");

        $num_row=mysql_num_rows($result);

        $result2=mysql_query("SELECT * FROM books ORDER BY title");

        $all_rows=mysql_num_rows($result2);



/*start showing the data found*/

                echo "<font face=\"tahoma\" size=\"2\">Number of Books records found : <b>" . $all_rows . "</b></font><br>";



for ($i=0; $i < $num_row; $i++)       {

            $row=mysql_fetch_array($result);

            echo "<font size=\"2\" face=\"tahoma\" color=\"#686898\"><br><b>" . ($i+1) . '. <u>Title</u>: </font>';

            echo "<font size=\"2\" face=\"tahoma\" color=\"#686898\">" . htmlspecialchars(stripslashes($row['title'])) . '</b></font>';

            echo "<font size=\"2\" face=\"tahoma\"><br><b>Auther: </b>" . stripslashes($row['authF']);

                echo ' ' . stripslashes($row['authL']) . "<br>";

                echo '<b>Book Number: </b>' . stripslashes($row['bookID']);

                echo '<br><b>Price: </b>' . stripslashes($row['price']) . ' SR</font> <br>';

}



/*if the user is not in first page .. print "previous page" link*/

              if ($start_row != 0) {

                         echo "<a href=\"show.php?start_row=" . ($start_row2-=10);

                         echo "\"><font size=\"2\" face=\"tahoma\">Previous Page</a></font>";

                         echo ' - ';

              }



/*print the next page link to view other books*/

            if ($num_row >= 10 ) {

        echo "<a href=\"show.php?start_row=" . ($start_row+=10);

        echo "\"><font size=\"2\" face=\"tahoma\">Next Page</a></font>";

             } else {

        echo "<font face=\"tahoma\" size=\"2\">Next Page</font>";

        mysql_close();

        } 

[Gordon Freeman]

hey thanks!

i'll try to mess with this tonight