Posted by Jerry Stuckle on 10/28/07 13:15

joanna wrote:
> On Oct 28, 7:53 am, bmic...@gmail.com wrote:
>> 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
>
> It kind of helps, the order by is something that was needed. However,
> maybe I wasn't clear, but I'm having a tough time trying to paginate
> the rest of the results as in a "next" and "previous" link at the
> bottom. The results are in the thousands and doing a manual page for
> each 100 results would be too much.
>
>

No, please reread bmichel's comments. His answer is correct on how you
should be paginating your results.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]