Jeromie thanks for the info. I'll have a look into smarty - never heard of it before.
I've figured a way around it that will work for me. Query a database using id and getting the top ($items_per_page * ($page_number -1)) then run another query with id selecting the next $items_per_page where not in the first query. The running another query where the items are in the 2nd query but getting all the data i need. If that makes sense? :) I think it's too early in the morning but i'm having issues actually getting the number of rows as a number. Keeps dishing out as an array and can't figure it out. How can i get $total_rows to actually equal a number using COUNT() Ok, this is stoopid - im off to get a coffee, maybe that'll help thanks Matt > The Smarty Template Engine (http://smarty.php.net/) plus some quick > adjustments to your query works great. > If you're doing something where the data doesn't change much, you might > want to check out the PEAR module Cache::Lite. It caches the output of > >>Anyone have any ideas or code snippets for Pagination (i.e. < PREV 1 > 2 3 > >>4 NEXT > ) when using a query on an MS SQL database? [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
