Digital Workshop

Does anyone know how I can list the results of a database search in a clickable and listable format?

I want to do a search, then I want the results to show on one page, it would be good if the results were grouped into 10s so page a would show 1-10, page b 11-20 etc.

Later I would like it to be sortable as well.

I can do this in HTML/PHP/MySQL but at the moment I'm finding it a little tricky in Opus.

Any help would be appreciated

I use textboxes and an array.

myArray[0+myOffset]
myArray[1+myOffset]
myArray[2+myOffset]

feed the dataset into the array elements. The offset allows you to scroll through the array elements by increasing or decreating it's value.

The SQL statement can sort the records before returning them by the way.

There is a working example of using arrays this way on my website in teh download section - called Opus Functions. I use it to create a dynamic menu system.

Mack

Hi Mac,

I am looking for the example on your site - pertaining to this thread, but cannot see it???

Regards

Pete

http://www.live.interaktiv.co.uk/index. ... &Itemid=19

Second item down, I think.

Mack