Posted by bmichel on 10/28/07 11:53

If I understand your problem correctly; you're having problem
distributing the SQL query on several pages.

By using ORDER BY, you can keep track of what was displayed already.

SELECT ID,Title
FROM table
WHERE Title LIKE '" . $_GET['title'] . "%'
ORDER BY title
LIMIT 0, 100

Depending on how many results you want to display per page (let's say
100). You can modify the LIMIT. That is for page 1 'LIMIT 0, 100', for
page 2 'LIMIT 100, 200' and so on

>> echo "<td><a href=\"page2.php?title=" .$title. "\"> $title</a></td>
This here looks like a bad design idea. You should instead have a
variable (which you can pass through $_GET), which tells you which
page you're on.

$params = "?title=" . $title . "&page=" . $page;

Hope this helps

[Back to original message]