daveh33 Posted February 1, 2008 Share Posted February 1, 2008 I am trying to execute the below query $start=100; $finish=105; $result=mysql_query("SELECT * FROM $tablename LIMIT $start,$finish") or die(mysql_error()); echo "<b>Starting Row: <u>$start</u><br /> Finishing Row: <u>$finish</u><br /></b> <br />Number of rows found: $numrows<br />"; This should get 5 rows - but when I run it, it picks up 105- it ignores the start & just limits from start of db until $finish Any ideas?? Quote Link to comment https://forums.phpfreaks.com/topic/88877-solved-mysql-limit-function/ Share on other sites More sharing options...
pdkv2 Posted February 1, 2008 Share Posted February 1, 2008 The result is correct ! the limit works as follows LIMIT start,num_of_records_to_fetch. Cheers ! Quote Link to comment https://forums.phpfreaks.com/topic/88877-solved-mysql-limit-function/#findComment-455219 Share on other sites More sharing options...
Guardian-Mage Posted February 1, 2008 Share Posted February 1, 2008 $start=100; $finish=5; #If you do the math, this is right $result=mysql_query("SELECT * FROM $tablename LIMIT $start,$finish") or die(mysql_error()); echo "<b>Starting Row: <u>$start</u><br /> Finishing Row: <u>$finish</u><br /></b> <br />Number of rows found: $numrows<br />"; Happy Coding Quote Link to comment https://forums.phpfreaks.com/topic/88877-solved-mysql-limit-function/#findComment-455224 Share on other sites More sharing options...
pdkv2 Posted February 1, 2008 Share Posted February 1, 2008 yes, but your $finish variable will always contain the number of records you want to fetch Quote Link to comment https://forums.phpfreaks.com/topic/88877-solved-mysql-limit-function/#findComment-455227 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.