how to find a search result in paginated set of pages

[cretaceous]

I have paginated page sets..
and I have a search routine in a different html page

it works if the search result goes to a simple page with ten results (the limit count).
Using a href # will jump to my correct result - while also displaying surrounding results.

But if I have six paginated pages of ten results each and the requested result is like row 43, how do I tell the script to "go" to that page [in other words how to select the right rows via offset 'cos I dont know the offset value]

I guess I need a way to calculate the offset value of the row within the result (based on any ORDER BY criteria)

Does this just mean I do the query twice, once to get the row position, next to do the actual select query and pagination?

Or is there a better way :
here's some mock SQL of what I hope exists:
SELECT rowoffset(*) from stuff WHERE row_id=search_id ORDER BY $ordervar

[leatherback]

Hi,

there is a good tutorial on doing paginated results on this website. Just have a look under tutorials on phpbuilder.com.

In general, you'd want to pass the query-data with the links between pages, and specify the offset in your recodset to display.

[cretaceous]

i did it by first searching for the record within the set - counting how much it is offset
(dependent on the ORDER BY, so changes continually),
dividing it by 'number to view', then getting the floor value to seed the page routine.

I just thought there might be a better way to get a "position" value of where a single record is in a SELECT

[leatherback]

Ohh..

Have you heard of the offset part in a mysql query?

Select from table where .. offset limit
e.g.,
select from shoes_table where (color="brown") 12 1

\Have a look at mysql.org for specific specification of the select command.

[cretaceous]

thanks Leatherback I know how to do a limit select - as I said I was looking for a way of doing a query that identifies the position of a row within a select

now I know it cant be done without a preliminary select to loop through the values