Sorting a related records output in an arbitrary order

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

By cwuensche - 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 cwuensche - 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