PHP / MySQL select data and split on pages
posted on December 31, 2006, 10:29 am| Comments |
| Saqib Bilal posted on February 14, 2007, 9:47 am |
| i have a long pagination say 50 pages i want to split pages in to regular interval of 10 like 10......20,20......30,30......40,40.......50 any idea how to modify this code |
| Carlos posted on January 22, 2007, 5:39 pm |
| I get the following response Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$start_from, 20' at line 1 based on the following query; $sql = 'SELECT WGIOrdNo, ProjNo, ATTRefNo, CusName, CurDate, Status, Engr, SrvLn FROM rbsr_table LIMIT $start_from, 20'; ---------------------- Veselin: query needs to be in double quotes |
| Carlos posted on January 22, 2007, 5:03 pm |
| According to your article you are using the Limit clause with a variable. The link takes you to the MySQL docs and then states that the LIMIT clause does not allow variables?? Is this tutorial in MySQL 4x?? Thanks. ------------------------------ Veselin: it's a PHP variable not MySQL |