drop down list

Hi,

To do this, for any given product, you would need to know which field contains it's list of options. You could have a drop down called "optionsField" where you would select from a list of different field names. You could then use that value to select option values for that product.

For example:

<select name = "option">
<?php foreach ($record[$record['optionField'].":values"] as $value): ?>
<option value = "<?php echo $value;?>"><?php echo $value;?></option>
<?php endforeach ?>
</select>

In this example, we assume a few things:
1) optionField has a value that is the name of another field in your record
2) that other field is a multi value list (drop down or checkboxes)

Hope this helps get you started

So it is the second part where I run into the difficulty.
The field that is the multi value list - how is that set up in the
section editor? When I look at the list option, it seems the list then applies to all the products, not one specific record.
I want to be able to create the drop down list as shown in your code snippet, but have each item with a unique set of choices in the drop down list.

I added a text field called options.
Entered data in the field - vanilla,chocolate,strawberry

included the code below:

<?php foreach ($productsRecords as $record): ?>
<table cellpadding="3" cellspacing="0" border="0" width="100%"><tr><td align="left" valign="top" class="just">


<h1><?php echo $record['Name'] ?></h1>

Price: <?php if ($CURRENT_USER): echo "$".$record['Price'] ; endif ?><?php if (!$CURRENT_USER): echo "<a href='http://website.com/login.php'>Login to see price.</a>"; endif ?><br/>
Product ID: <?php echo $record['Product_id_sku'] ?><br/>
<select name = "option">
<?php foreach ($record[$record['options'].":values"] as $value): ?>
<option value = "<?php echo $value;?>"><?php echo $value;?></option>
<?php endforeach ?>
</select>
<?php echo $record['Summary'] ?><br/>
<?php echo $record['options'] ?>
<br/>
<a href="<?php echo $record['_link'] ?>">Click for More Details</a><br/>

The options are shown as entered where the echo statement is.
The drop down box is not populated, just blank, no options.

Joe

Thanks Robin,

So doing as you said, then going into the product editor, the check boxes are there, displays the information, checked the boxes - but no show on the public display pages.

If I include <?php echo $record['options'] ?> it will output all the items that are checked in the product editor.

It appears this section of code is not returning any values or records.

<select name = "options">
<?php foreach ($record[$record['options'].":values"] as $value): ?>
<option value = "<?php echo $value;?>"><?php echo $value;?></option>
<?php endforeach ?>
</select>

--
Any thoughts on why it is not displaying the records?

Thanks,

Joe

Hey Joe,

A little fix to your foreach loop will probably help:

<?php foreach ($record['options:values'] as $value): ?>

If you ever want to see the structure of the data in $record - you can use a line like this:
<?php showme($record); ?>

Hope that helps,
Robin

Thanks Robin,

That Works!