Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Display random records or next 5 records when a page is refrshed

Display random records or next 5 records when a page is refrshed

Thread began 8/08/2015 9:36 am by mel321998 | Last modified 8/10/2015 11:39 am by mel321998 | 571 views | 1 replies

8/10/2015 11:39 amRay BorduinWebAssist

To show a random set of rows you can use: ORDER BY RAND()

Just add that to the end of your SQL statement.

To automatically show the next 5 rows you would probably have to add a session variable to keep track of the current page and increment it by one with each page refresh. Then you can add code above the recordset to set the page number variable to the value of the session variable.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.