Add prev/next buttons to navigate through CATEGORIES

[picandnix]

Hi.
I have a project where I simply have one product per category, hence the categories skip direct to the product. I would like to add navigation buttons to the *product page* that would navigate to the next *category* therefore making it possible for customers to navigate as if the category had multiple products as would be the more normal case.
The simple solution, of course would be to have one category with all the products in that category, but I want to avoid this ideally.
tkd revision dot com

Thank you

[picandnix]

A polite bump please.

[gjh42]

You need custom code that uses the current category id or cPath (available from the URL as $_GET['cPath']) to look up the previous and next categories (by sort orders? or ??), then populate buttons with those cPaths in the URL. How would you determine the prev/next order that should be followed? Will these all be top cats, or is there a hierarchy? Hopefully somebody will feel like writing out the actual code to do this.

[gjh42]

You need a SQL query to select * from the categories table, order by ??your criteria. Then you can find the location of the current category in the resulting array and step backward and forward in the array to get the desired destinations.

[picandnix]

You need a SQL query to select * from the categories table, order by ??your criteria. Then you can find the location of the current category in the resulting array and step backward and forward in the array to get the desired destinations.

Hmm, you lost me there lol.

[gjh42]

Meta-code :) not real code, but describes the sequence of what it should do... You can help by clarifying the questions I posted on criteria.

[picandnix]

Thank you Glenn.
Yes hopefully indeed...anyone seen Lat9 today?