[Scriptex]

For some reason when this code executes it's been displaying no results, and just a page number. I have the exact same setup minus the pagination code, and it's working fine I'l in include the links just for reference ~~
FarCry - Mollio (broken with pagination included)
Our Movies Organized By Year (w/out pagination)
and here is my coding that is giving me the error

PHP Code:

<?php



$result = mysql_query("SELECT * FROM movies ORDER BY year");



$page = $_GET['page'];

    echo "<ul>";



$pagedResults = new Paginated($result, 100, $page);



while($row = $pagedResults->fetchPagedRow()) 

    {    //when $row is false loop terminates

  echo "<li>";

  echo $row['title'];

  echo " " . $row['year'];

  echo "<li>";

  echo "<br />";

  echo '<a href="quotes.php?movieid=' . $row['id'] . '">' . 'Click to view quote for '. $row['title'] . '</a>';

  echo "<p>" . "</p>";

  

  }



      echo "</ul>";

        //important to set the strategy to be used before a call to fetchPagedNavigation

$pagedResults->setLayout(new DoubleBarLayout());

echo $pagedResults->fetchPagedNavigation();

mysql_close($con);

?> 

        

            

        

            

            <div id="footer">

            <p>A note here to go in the footer</p>

            <p><a href="#">Contact Us</a> | <a href="#">Privacy</a> | <a href="#">Links</a></p>

            </div>

            

        </div>

        

        

    </div>

    

</div>

</body>

</html>

[dgreenhouse]

I'm not familiar with nor do you show the basis of the class: Paginated.

But...

I can tell that if the class requires a full result set (as shown by your select statement) to operate properly, then it is possibly flawed and inefficient.

A proper pagination routine should be based on the page number requested plus the number of "pre-defined or user-selectable" results to be displayed per page.

i.e.
SELECT * FROM movies LIMIT 0,100
- or -
SELECT * FROM movies LIMIT 100 OFFSET 0

You could then use the page# requested to calculate the OFFSET.

i.e.
define("RESULT_LIMIT",100);
$page = isset($_GET['page']) ? (int) $_GET['page'] : 0; // ensure we get a numeric
$page = $page * RESULT_LIMIT; // set the page offset
$sql = "SELECT * FROM movies LIMIT $page OFFSET ".RESULT_LIMIT;
// Output pagination at top
// Output results in a loop or from a module...
// Output pagination at bottom

There are numerous pagination classes and functions available on the net that will work for you.

A little pagination helper that I've used a few times in the past can be found here:
php easy :: pagination scripts set
It has a fairly small footprint and easy to use.
There are three functions included that you can pick from that use different pagination styles.
There is also a css file included that will style the pagination output.
You'll probably need to tinker a bit with it.

But as stated, there are many other (and better) "paginators" available online.

Hope that helps.