[FX.php List] Retrieving values from value list related fields

Bob Patin bob at patin.com
Wed Nov 8 09:18:06 MST 2006


I've got a value list that I'm pulling into my site; the value list  
is created from related fields, so each item in the value list has a  
record from which it's pulled.

My question: how do I retrieve a 2nd field for each of these value  
list items? For example, here is part of a value list:

Honda Accord
Honda CR-V
Honda Oddyssey

For each of these, there is a corresponding field that contains an  
image name for each vehicle; I need to give the user the option to  
display this value list either as a menu (which is how it's working  
now) or as a page of images.

I tried creating a 2nd value list containing the images, but they  
don't seem to always get sorted the same way.

When you pull a value list using PHP, does it get sorted, or does it  
stay in the same order in which it was stored? If the latter is true,  
then why do my images not always match up? Do they get alphabetized  
like they would for a pulldown in FileMaker?

For example, I have cases where there is

Chrysler PT Cruiser
Chrysler PT Cruiser Convertible

For whatever reason, these 2 images get switched, even though the  
filenames are correct in the database...

Thanks,

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060






More information about the FX.php_List mailing list