fields in a database

[SirLars]

I was curious as to how to make a field in a database support either an array of strings... (a text list)...
or an array of ip addresses, collected from a form, or added in from an asp page after a form.

i.e.
collecting game statistics from a group of friends keeping track by an asp page/form

table is set up like this
table_Players
Name, Wins, Losses, Points, TournamentWins, Last10Playersdefeated,Last10Playerslost, TournamentsWon, ip_address

where (name, wins, losses, points, and tournamentwins are all "self-explanitory (name and rest just integers))
Last10Playersdefeated, (i would like) would be an array of the last 10 players they defeated (p(1), p(2) etc.. which would be edited/changed by the form when they report a win or loss to a different form)
last10playerslost (same idea)
and ip_address i would like to cross-reference the ip addresses they are using by adding unique ip's used to that field (again on the form )

is this possible?

thanks in advance.

Lars

 

[DeZiner]

Check on linking tables where you would link last10playersdefaeted to another table called defeat or something. Check on table linking and using inner and outer joins in SQL. DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic