Next/Previous Entry

[Anon]

For a gaming site I am making I need functionality to show the next/previous game in alphabetical order from the game the user is currently viewing. The tables are not ordered alphabetically however.

The only way I can think of to do this is to select all game names in alphabetical order, seeking to the current entry, going back an entry and saving the value, going forward an entry and saving the value and then closing the result sets. I know that mysql_dataseek is far slower than doing the work inside the db engine itself, but I can't think of how to do this with MySQL.

Any help would be greatly appreciated,

Kevin Schachter

[Anon]

Yeah that doesn't seem like it would scale up very well if you have a huge number of games.

First thing you should do is build an index on (name,id) so that the selects will be quicker.

Also if your current game starts with 'C' for example, you could

select * from games where name between 'b' and 'd';

That way you limit how many games you're pulling out.

That works for postgres anyway - not sure about mysql.