Sorting a related records output in an arbitrary order

15 posts by 2 authors in: Forums > CMS Builder
Last Post: September 8   (RSS)

By Carl - September 3

I think one way you can solve the problem is to update your musician listings so they're sorted Alphabetically in the CMS Admin, and on the front-end wherever you're wanting to display the listings, you can re-retrieve the records using mysql_select and output the records by concert line-up order.

Carl

PHP Programmer

interactivetools.com

By gkornbluth - September 3

Hi Carl,

Thanks for thinking on this.

The sorting makes sense (to find the musician records for a specific concert).

Could you elaborate on the" re-retrieve the records using mysql_select and output the records by concert line-up order."

Not sure I know how to accomplish this part.

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By Carl - September 8

Try using this file and let me know if that solves the order output for the frontend aspect.

Carl

PHP Programmer

interactivetools.com
Attachments:

indexE-Test.php 14K

By gkornbluth - September 8

Thank you Carl,

I'm sure I'll have some questions when I look this over, (which unfortunately won't be until tomorrow..)

Jerry

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By gkornbluth - September 8

Hi Carl,

Thanks for the sample test page.

I'm sure that you have a path that you're following with this approach.

I stripped out some extraneous code from the tests and re-sorted the records so that the last concert still shows, and your code for the page at https://greenwichvillagefolkfestival.org/indexF-Test.php seems to work the same way that the code in https://greenwichvillagefolkfestival.org/indexD.php does, but yours certainly seems a bit more straight forward.

I'm still at a loss though as to how to re-sort and add or subtract musicians (pills in the pillbox) for a specific show lineup.

As I mentioned previously, even though this project is a labor of love for me, I'm willing to entertain paying for the ability to resort any pillbox entries sitewide, and to be able to add or subtract specific 'pills' anywhere in the pillboxes.

If it's at all possible, I'd like to be able to button this up before the lineup for the next concert comes up in a little less then 2 weeks.

Again, thanks for this,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php