var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
help with mysql's LIMIT
OK i have been stuck on this for hours
first of all this script shows results from rows in a table.
well, first off here is the code :
now then what that code is meant to do is display results, and if there are more than 10 results in the table, then show a next page link
$cat = $_GET['cat'];
$search_type = $_GET['search_type'];
$search_data = $_GET['search_data'];
$from = $_GET['from'];
$to = $_GET['to'];
$counter = 1;
$fetch_reviews = "SELECT postid, review_name FROM $cat WHERE review_name LIKE '%' LIMIT $from, $to";
$result = mysql_query($fetch_reviews);
while($data = mysql_fetch_row($result))
if($from != 0)
$previous_to = $to - 10;
$previous_from = $from - 10;
echo('<a href="search.php?cat='.$cat.'&search_type='.$search_type.'&search_data='.$search_data.'&mode=edit3&from='.$previous_from.'&to='.$previous_to.'">Previous Page</a> ');
if($counter > 10)
$next_to = $to + 10;
$next_from = $from + 10;
echo('<a href="search.php?cat='.$cat.'&search_type='.$search_type.'&search_data='.$search_data.'&mode=edit3&from='.$next_from.'&to='.$next_to.'">Next Page</a>');
ok that works but i have a problem
there are eighteen matches in the table.
now when limit is LIMIT 0, 10 it displays the first 10 matches and then the nextpage link
when limit is LIMIT 10, 20 it shows, for some reason, all 18 matches, why???
then when limit is LIMIT 20, 30 it shows the last 8 pages, which should have been showed by LIMIT 10, 20
can anyone see what is wrong with my script???
ahhhh i found the problem
i miss understood LIMIT
i thought the first number of LIMIT was the row it goes from and the secound number was the row it goes to.
but its not, the second number is how many results it displays (matching the query u set) and the first number is where it starts from.
so that last number should always be 10