Problems selecting product colour

[woolnstuff]

Hi

Having problems with one of our products in that what ever colour you select you get the one immediately above it on the list. Here is the link to the product:

http://www.woolnstuff.co.uk/acatalog...ting_Yarn.html

All the other products are fine (as far as I know) and I don't no if it matters but it did manage to delete itself the other day. I just right clicked and selected undelete to get it back.

Any ideas how to fix it without having to delete it and start again.

Regards

Vickie

[Mike Hughes]

Very wierd.

The first one I selected worked correctly, the second one had no colour and the third on had the one higher up the list, as did the fourth. The fifth had no colour again and the sixth was the next one up again.

Looking at your code some of the option values are all messed up:

<option value="1">Plum (905)</option>
<option value="2">Emperor (906)</option>
<option value="3">Raspberry (907)</option>
<option value="4">Beige (925)</option>
<option value="5">Petrol (926)</option>
<option value="6">Lavender (927)</option>
<option value="0">Emerald (784)</option>
<option value="7">Gold (55)</option>
<option value="8">Scarlet (9)</option>
<option value="9">Royal (21)</option>
<option value="10">Clerical (49)</option>
<option value="11">Bottle (33)</option>
<option value="12">Wine (32)</option>
<option value="13">French Navy (25)</option>
<option value="14">Chocolate (23)</option>
<option value="15">Aran (46)</option>
<option value="0">Bluebell (26)</option>
<option value="16">Dusky Pink (94)</option>
<option value="17">Sky (5)</option>
<option value="18">Oatmeal (41)</option>
<option value="19">Irish Navy (52)</option>
<option value="20">Copper (109)</option>
<option value="21">Linden (165)</option>
<option value="22">Fuchsia (787)</option>
<option value="0">Aubergine (773)</option>
<option value="23">Caramel (790)</option>
<option value="24">Turquoise (18)</option>
<option value="25">Bilberry (788)</option>
<option value="26">White (1)</option>
<option value="27">Black (48)</option>
<option value="28">Olive (69)</option>
<option value="0">Larkspur (13)</option>
<option value="29">Heather (162)</option>
<option value="30">Graphite (702)</option>
<option value="31">Cranberry (703)</option>
<option value="32">Silver (36)</option>
<option value="0">Lilac (17)</option>
<option value="0">Asparagus (785)</option>
<option value="33">Bronze Green (43)</option>
<option value="34">Slate Blue (96)</option>
<option value="0">Chestnut (789)</option>
<option value="35">Kingfisher (771)</option>
<option value="36">Denim (791)</option>
<option value="37">Dill (792)</option>
<option value="38">Magenta (793)</option>
<option value="39">Corn (794)</option>
<option value="40">Rouge (795)</option>
<option value="41">Beech (796)</option>
<option value="42">Sugar Pink (797)</option>
<option value="43">Sage (853)</option>
<option value="44">Fern (854)</option>
<option value="45">Mustard (855)</option>
<option value="46">Bark (857)</option>
<option value="47">Pink (858)</option>
<option value="48">Saxe (859)</option>
</select>

Those "0" value ones are wrong.

You could try compacting your database but I suspect you might have to recreate this from scratch again.

Or maybe, just maybe, you could delete the rogue entries and then recreate just those problem ones again. Do compact the database first though as something has got screwed up.

Mike