Double checking the database, I note that my client has entered the products' product ID (LEDid) in the parentID field so in effect it is the parent of itself. That is my mistake for not spotting that.
Upon rectifying that, having changed the IF statement as advised above, there are still problems and, like I said, it was working for every other product so I disagree with your insistence that that's why it isn't working.
I have changed it back to:
<?php if ($totalRows_rsCOLOUR > 1) { ?>
...and it's working so it was the parentID issue at fault.
Thank you and sorry for not spotting that sooner.
NJ
EDIT....
If it was <?php if ($totalRows_rsCOLOUR > 0) { ?> then if there was only one colour option it would still display the drop-down, which would be pointless. That's why it's set to <?php if ($totalRows_rsCOLOUR > 1) { ?>
