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

Hi

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

Regards

Daniel
gingerwingerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Havin_itCommented:
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 www.macromedia.com (look for the Dreamweaver Exchange) and www.dmxzone.com 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

$list[0]['foo']

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gingerwingerAuthor Commented:
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

Daniel
0
triserosCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Dreamweaver

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.