Filter multiple sizes result

Hey Paul,

If your current code is not working, you can try using array_unique after the loop and remove all duplicates at once. Something like this:

foreach ($clothingRecords as $record) {
$sizeRecords[] = $record['size'];
}
$sizeRecords = array_unique($sizeRecords);

Hope that helps,
Robin

Hello Robin :)

I tried the code you suggested but it made no difference. To be honest I may not be explaining myself very well.


If you look at the sizes drop-down it lists they like this:
Selection 1: 32AA 34C 36C 38B
Selection 2: 30D 32C 32D 34A 34B 34C 36A 36B 36C 36D 38B

I understand why it's presented like this, because of the way I specify the sizes (I have attached an image of how they are specified), but what I need to do so that the search function works, is for all the size options generated to be listed as individual options, with any duplicates removed, so that the drop-down shows:

30D
32AA
32C
34A
34B
34C
36A
36B
36C
36D
38B

I know I need to create a new array with them sorted but I can't seem to quite get it. Hope this makes better sense lol!

Thanks :)

Paul

OK, thought I would share this as you never know who will end up with the same problem :)

There were a number of odd factors that I found out that I was dealing with. For example spurious /t (tab) characters etc. Any way here is a documented breakdown of what I did to resolve the problem:

<?php foreach ($clothingRecords as $record):

$sizeRecords[] = $record['size'];
$sizeRecords = array_unique($sizeRecords);

endforeach;

$sizeRecords2 = join("",$sizeRecords); // merges arrays into a string

$sizeRecords2 = str_replace ("\t", ",", $sizeRecords2); // removes /t (tab) from string (not sure how it gets in there), and replaces with comma

$sizeRecords2 = str_replace (",,", ",", $sizeRecords2); // removes the double comma that is created by the above function because of double /t (tab) in between each new array that is merged

$sizeRecords2 = (substr($sizeRecords2,-1) == ',') ? substr($sizeRecords2, 0, -1) : $sizeRecords2; // removes the last comma on end of string

$sizeRecords2 = ($sizeRecords2[0] == ',') ?

substr($sizeRecords2, 1) : $sizeRecords2; // removes the first comma on start of string

$sizeRecords3 = explode(',', $sizeRecords2); // Explodes string into an array

$sizeRecords4 = array_unique($sizeRecords3); // Removes Duplicates from array

asort($sizeRecords4); // Sorts array into numeric order

?>

There is probably a more efficient way to do this, but I am still proud of myself for getting to this stage.

...and again thanks to Robin for his input :)

Paul

So I have 2 issues with the above after more testing.

Issue 1: I would like to be able to sort the sizes showing the Alphabetical content first followed by the Alphanumeric

Issue 2 (the most serious): When I specify the size in the drop down and the search is done. The size drop down then lists ALL the sizes available from the items listed. I would like it to show ONLY the size selected initially. This is important for another reason. If a brand has both bras and briefs, and the user selects bras, then the resulting output show bras for all brands, not just for the brand selected initially.



Any ideas?

Thanks

Paul

Hey,

1.
It's a bit advanced, but you can do a custom sort with usort()
http://www.php.net/manual/en/function.usort.php

2.
CMS Builder has a handy function called selectedIf which will let you test if a menu should have a default value. So in the code that builds your size menu, something like this should help:
<select name="size" >
<option value="">All</option>
<?php foreach ($sizeRecords as $record): ?>
$record
<option value="<?php echo htmlspecialchars($record) ?>" <?php selectedIf($record, $_REQUEST['size']); ?> ><?php echo htmlspecialchars($record) ?></option>
<?php endforeach; ?>
</select>
Hope that helps,
Robin