How to show result of recordset plus the next record somewhere else on page

Posted on 2004-11-10
Last Modified: 2010-04-03

I was wondering how to go about showing a record within a recordset and somewhere else on the page shows the next record in line.  Is this possible?  I would also like it to update when someone clicks next which in turn updates the next record data.

I know how to do ordinary recordsets but can't think how to show the next record somewhere else.

Any suggestions how to do this would be a great help


Question by:gingerwinger
    LVL 10

    Accepted Solution

    Hi Daniel,

    You didn't mention which server-technology you are using, so I'll assume PHP as it's the only one I've worked in myself. First-off, DW's options for recordset display are limited. Whether they solve your specific problem or not, it's worth having a look at (look for the Dreamweaver Exchange) and both of which have a lot of free extensions to improve scripting support in all languages.

    Having said that, here's a simple method of converting a multi-row recordset into a numeric array of arrays that can be re-used (unlike a DW Repeat Region behaviour).

    $list = array();
    do { $list[] = $row_yourRecordSet; }
    while ($row_yourRecordSet = mysql_fetch_assoc($yourRecordSet));

    Then you can access row 1, column 'foo' as


    Hope that's some use. I guess the principle extends to other languages...

    Author Comment

    Thanks for your reply...

    I am using ASP but I'll take a look at what you have suggested and get back.

    Thank you for your time

    LVL 1

    Assisted Solution

    Create your recordset then, in the html code between your first record and second record add the following

    <% yourRecordsetName.moveNext %> ' this will now move the recordset to the next record

    If you can give me some more info on the function of updating I can help you there too but the moment that should at least fix the display issue

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Suggested Solutions

    For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
    I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now