confusion with where query and arrays

[eluser]martynrlee[/eluser]
Appreciate your help mddd - can you give me any more info with the link tables.

I cant quite work out how it would be different even if I had a separate table for colours and each row in the main table linked to the other table.

Would it not be like this..

Colour table:
id - 1, colour - blue
id - 2, colour - green
etc

Main table:

id -1, colours - 1,2.


Any more advice?