quasiman Posted February 15, 2008 Share Posted February 15, 2008 I'm attempting to use a pagination script I've found, but I'm not getting it to output into my records correctly. Here's the link to the pagination script (they don't have a forum for help over there) http://www.goodphptutorials.com/out/Simple_PHP_MySQL_Pagination Here's the pagination class and sql query that I'm trying to use, and I think the only real problem with it is the sql: <?php // create the pagination class $pagination = new Pagination(); $pagination->setLink("search_log_results.php?page=%s"); $pagination->setPage($page); $pagination->setSize($size); $pagination->setTotalRecords($total_records); //Find the search string and type from the database: $getlogs = mysql_query("SELECT * FROM logs WHERE username LIKE '%$string%'" . $pagination->getLimitSql() . "ORDER BY logid DESC", $sqlconnection);?> And the paging links: <?php $navigation = $pagination->create_links(); echo $navigation; // will draw our page navigation ?> No errors, but it doesn't display any records either...any help would be appreciated! Quote Link to comment https://forums.phpfreaks.com/topic/91319-php-pagination/ Share on other sites More sharing options...
quasiman Posted February 16, 2008 Author Share Posted February 16, 2008 nevermind, I got it Quote Link to comment https://forums.phpfreaks.com/topic/91319-php-pagination/#findComment-468182 Share on other sites More sharing options...
azfar siddiqui Posted March 9, 2008 Share Posted March 9, 2008 good .. if you want some more paging scripts.. just email me Quote Link to comment https://forums.phpfreaks.com/topic/91319-php-pagination/#findComment-487533 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.