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

[Dale Bengston]

Hi Bob,

I would think you'd need to do a query to create an array containing  
your dual value list information. Then you can use that same array to  
draw a popup (or list of text links, or whatever) and another element  
of it to display your list in thumbnail view. Doing it this way will  
allow you to make sure the sort is the same for both.

Regards,
Dale

On Nov 8, 2006, at 10:18 AM, Bob Patin wrote:

> 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
>
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list