Arrays in database table columns?

[tommychi]

I was just wondering if it was possible to store arrays in the columns of tables that are in the database? And if so, how i would go about pulling these values out? The reason i ask is because currently im creating an RPG, and there needs to be items. However, each time you BUY an item, your stock goes up and you carry more and more items. All these items would be stored in an array and im just wondering if this array could then be stored into a database column. Any help would be appreciated.

[mrhappiness]

http://www.php.net/serialize
http://www.php.net/unserialize

hth

[tomhath]

Or you could use the "implode" or "join" and "explode" or "split" functions. But it might be better to have another table in your database with a row for each item. Then you can insert, delete, and search more easily IMHO