paginate - limits??

[marq]

I have a paginate script running, however there are several thousand results returned on every search, i can tweak it so it only shows say the first 200 or so, however this is done on the client side, the code still selects all the data from the database - i cannot limit the results in the sql select statement as the php side uses this already;-

$sql = mysql_query("SELECT * FROM book LIMIT $from, $max_results");

How do i get the php script to only draw the first 200 results rather than collecting several thousand and having to inefficiently filter the data????
Any and all advice most welcome
thanks in advance

[RicScott]

	$display = 200;

$query = "SELECT COUNT(*) as Num FROM book";
	$result = @mysql_query ($query);
	$row = mysql_fetch_array ($result, MYSQL_NUM);
	$num_records = $row[0];

// Calculate the number of pages.
if ($num_records > $display) { // More than 1 page.
	$num_pages = ceil ($num_records/$display);
} else {
	$num_pages = 1;
}

} // End of np IF.

// Determine where in the database to start returning results.
if (isset($_GET['s'])) {
	$start = $_GET['s'];
} else {
	$start = 0;
}

Then after your pagination run the query...

$sql = "SELECT (list all your cols instead of using *) FROM books";
$result = @ ($sql); // Run the query.

$result = @ ($sql); // Run the query.