how to move to first and last record

[Anon]

is there anyway in php where i can move to first and last record of a particular table

thankx

kaushal

[[deleted]]

Only if you can identify the records by for ex: an auto_increment field.
You can get the min(ID) and max(ID) and select those records.
Or if your table is small and you have enough resources you can select * and use mysql_data_seek() to go to the first and last result in the resultset.

[kparker]

More generally, in a real dbms (which you may or may not be talking about) there is no concept of first and last record from the client's perspective. You are deliberate told nothing (and can find out nothing) about the physical storage arrangments that the server may be using to keep the data on file.

If you've issued a query that includes an ORDER BY clause, that's a different matter: you can meaningfully talk of a "first" and "last" row relative to the results returned by a particular query.