[SOLVED] List style?

[lpeek]

Hey

i know this is probs one of the most noobish questions you've heard but....

Using MySQL, do i use the collumn type 'Text' if i want to use lists? or is there a special methood of doing a list style thing?

Basically what i want is where the user joins a group kinda thing... but they can join more than 1... i dont want to make about 100 collumns just so they can join 100 groups... ?

Anyone?

Thanks
:thumbsup:

[felgall]

One column for the username and one for the list that they join. The two fields together make a unique key for the table and they can join two or twenty thousand lists while still having the table work properly.

[guelphdad]

that's right, a new row in that table for each list someone joins. they join 125 lists? then there are 125 rows there for them. See this article (http://www.guelphdad.wefixtech.co.uk/sqlhelp/lists.shtml) for more info.

[lpeek]

Ah yes! so stupid of me, i should have known to do it this way lol

thanks for your help.