Whats a different way to do this?

[dreamkat]

So I have a trade system already,
In mysql, It has a 'trades' table.It has the trade information(that stuff doesnt matter) and 'item wanted' and 'item desired' fields.
The values are the item ID wanted or desired.
I wanted a way to have multiple item wanted and desired fields without creating a bunch of fields. Any Ideas?
Thank you. 🙂

[bradgrafelman]

Create 2 new tables and call them something like trade_items_wanted and trade_items_desired.

In each table, you'd have two columns (both foreign keys) - trade_id and item_id. Then you'd just insert 1 row per item wanted/desired for each trade in the appropriate table.