RE: FN-FORUM: Choosing the next record in MySQL DB

date posted 14th May 2008 06:21

> But I don't know an easy way to do this without testing each higher and
> lower number until I find a valid ID. (Some articles are deleted so
> there is not a continuous sequence.
>
> I recall reading something about a cursor which keeps track of where
> you are in the table, but cannot find out how to manipulate it to
> retrieve records.

I would have thought the best way to do this would be through the use of
multiple recordsets, if you're using mySQL 5 then you can do this in a
stored procedure and use output parameters to return these additional
values.

HTH

--
Colin Shipton
Intrafusion Website Design & Development
http://www.intrafusion.co.uk
http://www.linkedin.com/in/intrafusion