[ic] Next Product, Previous Product.
docelic at spinlocksolutions.com
Thu Oct 2 22:59:48 UTC 2008
> Something like this would work (untested):
> sql="(select sku from products where id < $THIS order by id desc
> limit 1) union all (select sku from products where id > $THIS order
> by id limit 1)" list=1
> [sql-alternate 2]
> Previous product, [sql-code]
> Next product, [sql-code]
In the above, $THIS would be the current SKU, of course,
and [else] needs to be closed with [/else][/sql-alternate].
More information about the interchange-users