[RESOLVED] Arrays into a MySQL cell

[Scarum]

Hi.
I've been trying for some time to place variable arrays into a MySQL database, in a single cell. The data inserted will be integers only. So far, I've only puzzled ut the actual syntax for inserting, and it runs something along the lines of this (Don't worry about the INSERT code, just the latter VALUES bit.

mysql_query('INSERT INTO tablename VALUES (' . implode(',', array_map('quote_smart', $result[0])) . ')');

If anyone can reccomend a better way of doing this, please let me know. Also, I would appreciate it if anyone could also post a good reverse of this, as in take the imploded array and break it up into the component parts it was in before. You'll probably need to use the explode function. Thanks.

[deezzer]

Because i want multiple things inside my database, but i dont know wither to use arrays inside a single cell (like your post) or to have different columns for each element, that way, there's no headache with the imploding/exploding, and when the user deletes an element in an array, i'm scared things could get messy when you try to test that your data resorts correctly.

my question could be one backwards from yours, which is:
what is the best way to add more than 1 element in a database while maintaining scalability and the most simpliest way?

Guru please help us.

[dr_bung]

http://us2.php.net/manual/en/function.serialize.php
http://us2.php.net/manual/en/function.unserialize.php

[Scarum]

🙂 Thanks!