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?? 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 ! 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 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 Link to comment https://forums.phpfreaks.com/topic/88877-solved-mysql-limit-function/#findComment-455227 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.