How to skip row in a WHILE statement

[nomad9]

Hi !

I've got a db table like this :

---

listID | listName | listBlue | listRed | listYellow | listBlack

1 Norois Blue Black
2 Polo Red Black

3 Interlude Red Yellow

So, as you see, each productName have is own option of color. Now what i want to do is to display these row (WHILE ...) but how to skip the field with no value ???

[nomad9]

Oups ... my table doesn't working :mad:

What i want to do is to display the list of my product with is optionnal color.