first entry in a joined list variable being skipped

Hi Jerry,

I can't see anything obviously wrong with your code, would you mind running a showme function on your store_inventoryRecord variable so I can see how the data is set up? 

showme($store_inventoryRecord);
exit;

You need to run this after the $store_invetoryRecord is created in the top of your PHP file. Then if you could copy the array that is output into a post for me I can see what the problem is.

Thanks!

Greg

Here you go: If I've missed anything, you can see the entire output at http://www.rcartierperry.com/storeadetail-showme.php?Clothespin-Pattern-1-Stone-Colors-1-1 and I've attached the page code.

Array

(

[_filename] => Clothespin-Pattern-1-Stone-Colors-1

[_link] => /storeadetail.php?Clothespin-Pattern-1-Stone-Colors-1-1

[_tableName] => store_inventory [artwork_for_sale_on_line] => 1

[artwork_for_sale_on_line:text] => Yes

[colors] => 2 5 1 3

[colors:labels] => Array

(

[0] => Blue

[1] => Gold

[2] => Red

[3] => Platinum )

[colors:values] => Array

(

[0] => 2

[1] => 5

[2] => 1

[3] => 3

)

And thank you

Hi Jerry,

There isn't an image key in the array that you posted. Yet your getRecords function is loading uploads, and your page is displaying the images correctly so it looks as if they should be in there. Was this the contents of the entire array? 

Thanks!

Greg

Hi Jerry,

I'm still not sure what is causing the problem, but it might because Blue is the first item in the string, and so doesn't have space and comma first. Perhaps you could try using this to detect if the color has been selected or not:

<table>
  <tr>
    <td colspan="2">
      <?php $colors1 = join(', ', $store_inventoryRecord['colors:labels']); ?>
      <span class="navigation_font">Available Colors: <?php echo $colors1 ?></span><br/>
    </td>
  </tr>
  <tr>
    <?php foreach ($store_inventoryRecord['image'] as $upload): ?>
    <?php $info1 = $upload['info1'] ?>
    <?php if(in_array($store_inventoryRecord['colors:labels'], $info1)):?>
      <td align="center">
        <span class="sub_heading_font"><?php echo $upload['info1'] ?></span><br /> 
        <img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" />
      </td>
    <?php endif ?>
    <?php $maxCols=2; if (@++$count % $maxCols == 0): ?></tr><tr><?PHP endif; ?>
  <?php endforeach ?>
  </tr>
</table>

So instead of checking if the color is in a string, we check if it's in the labels array instead. 

Thanks!

Greg

Very perceptive, but when I try the code you suggested, I get the errors:

Warning: in_array(): Wrong datatype for second argument in /hsphere/local/home/c382004/rcartierperry.com/storeadetail.php on line 169 Warning: in_array(): Wrong datatype for second argument in /hsphere/local/home/c382004/rcartierperry.com/storeadetail.php on line 169 Warning: in_array(): Wrong datatype for second argument in /hsphere/local/home/c382004/rcartierperry.com/storeadetail.php on line 169 Warning: in_array(): Wrong datatype for second argument in /hsphere/local/home/c382004/rcartierperry.com/storeadetail.php on line 169

Interesting that there are 4 errors and 4 images

Jerry

Oops! 

I've got the two variables in the in_array the wrong way around. I'm going to blame PHP's inconsistent use of needle/haystack in functions. ;-) 

Try this instead:

<table>
  <tr>
    <td colspan="2">
      <?php $colors1 = join(', ', $store_inventoryRecord['colors:labels']); ?>
      <span class="navigation_font">Available Colors: <?php echo $colors1 ?></span><br/>
    </td>
  </tr>
  <tr>
    <?php foreach ($store_inventoryRecord['image'] as $upload): ?>
    <?php $info1 = $upload['info1'] ?>
    <?php if(in_array($info1,$store_inventoryRecord['colors:labels'])):?>
      <td align="center">
        <span class="sub_heading_font"><?php echo $upload['info1'] ?></span><br /> 
        <img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" />
      </td>
    <?php endif ?>
    <?php $maxCols=2; if (@++$count % $maxCols == 0): ?></tr><tr><?PHP endif; ?>
  <?php endforeach ?>
  </tr>
</table>

Cheers

Greg

Hi Greg,

That seems to have solved the issue, so I guess that your guess was a good guess.

Thanks,

Jerry