MySql - First and Last record

[Phrank]

I have been programming in Foxpro for quite a while. New to PhP/MySql.

Can someone point me to the code to get the first record from a mysql db - The last record - The next record - The previous record?

In Foxpro it is always

Go Top
Go Last
Skip -1
Skip

TIA

[Yamakazi]

If you only want the first record:

select * from table where this = 'this' limit 1;

last record

select * from table where this = 'this' order by key desc limit 1;

Next and previous you should create that yourself with some coding boy :p

Create a scroll class or something. Just create something that works for you.[

[Roger_Ramjet]

No, the best that mysql can do is simple forward-only cursors in stored procs. If you want to traverse a recordset without repeated connections and queries you have to bung it into an array and track the index for yourself.