sandy1028 Posted August 22, 2007 Share Posted August 22, 2007 Hi, I have 7 columns in the table. The first 2 columns should not be changed and last 5 columns is used in pagination of columns. How can I proceed with this. Last 5 columns is users and when I click on NEXT the columns should change from A1 A2 A3 A4 A5 to A6 A7 A8 A9 A10. I should use pagination columnwise Please help me to proceed Quote Link to comment Share on other sites More sharing options...
xyn Posted August 22, 2007 Share Posted August 22, 2007 theres a tutorial found... http://www.phpfreaks.com/tutorials/43/0.php Quote Link to comment Share on other sites More sharing options...
sandy1028 Posted August 22, 2007 Author Share Posted August 22, 2007 Ok... But from 7 columns in a table is it possible to keep to two rows static and change the 5 last columns Quote Link to comment Share on other sites More sharing options...
xyn Posted August 22, 2007 Share Posted August 22, 2007 i think so... truy this... SELECT `field`,`field`,`field`, CASE WHEN `field_id`='1' THEN 1 ELSE 2 END as `bahsort` FROM `table` ... Quote Link to comment Share on other sites More sharing options...
vijayfreaks Posted August 22, 2007 Share Posted August 22, 2007 hi.. would u plz show with some dummy data.. how you want paging..? Regards, Vijay Quote Link to comment 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.