'Next' and 'previous' links

[andriy]

I have table with columns

text TEXT,
date DATETIME NOT NULL,
id INT AUTO_INCREMENT NOT NULL.

Earlier, in search script search.php I used the next SQL statement:
SELECT * from table WHERE (id>$id) && (text LIKE '%$text%') ORDER BY id DESC LIMIT 10;

"next" link was <a href="search.php?id=$id">

But now, I have to order search results by date. The problem is that field 'date' can be modified in other scripts. So i can not order by id. Also some rows possibly have the same date. So I can not use
SELECT * from table WHERE id>$id ORDER BY date DESC LIMIT 10;

What I should do?

Thank you.

[amcgrath]

Check out OFFSET... as in limit 10 offset 5 (or limit 10,5) basically offset means "start at this row".... that'll getcha where ya want to be...

[Anon]

ya
use

$sql="select a from b where a>10 limit $id,10";

$id is what u pass depending on next or previous

if ($traverse==next) $id+=10;
if ($traverse==previous) $id-=10;

<a href=a.php?traverese=next&id=$id>Next</a>
else if
<a href=a.php?traverese=next&id=$id>previous</a>

Please free to mail me at [e-mail] for more details.

Regards
Mandar Kelkar