Record Navigating

[edpudol]

How could I navigate to mysql database Assuming I want to goto to specific record then from there display the next records...

like xbase... command:

Goto record 21
display next

[Lucas Chan]

If I understand your question correctly, this page will be of some assistance:

http://au.php.net/manual/en/function...-data-seek.php

[edpudol]

thanks.. i think this helps..

[vinyl-junkie]

The way I do it is like this:

SELECT * FROM table LIMIT 10,20

This will either return records starting at record 11 (that's 10 plus 1, since SQL starts numbering from 0), or will return no records.

You must be careful with mysql_data_seek, because if you start with a non-existent record, you will get an error.

edited: Correction of record number retrieved using LIMIT clause. (I can't believe no one called me on that!)

[edpudol]

thanks vinyl-junkie for being there patiently answering my questions...

in this regard I have a follow up question about navigation...

I use this code to search a record:

Select * from tbl WHERE username = '$username' LIMIT $startATuserposition, 20"

That is my problem the $startAtuserposition how could I determine the current row possition of the said recor?

[vinyl-junkie]

Here's how I do it, only I have number of records per page stored in a variable, too. Hope it helps.

$RowStart = ($PageCurrent - 1) * $PageSize + 1;