arrays and MySQL

[CHeeSeBLiND]

can i store an array in a MySQL field? and if i can how do i do it?

i have an idea how to do it but i dont know if it would work.

if i store the values in a feild as folows:

'blue','red','yellow' ect

then i connect to the database and then carry out the following function

$colours = array($row[colours]);

would that work?

[cupid]

No, this will not work if you use the array function. $colours[0] will end up holding the value 'blue','red','yellow' instead of $colours[0] holding 'blue', $colours[1] holding 'red', etc.

What you CAN do is explode the string like so:

<?php

$colours = explode(",",$row[colours]);

/* now colours will be an array */
echo $colours[0];

?>

[hadley]

or use serialize/unserialize (http://www.php.net/serialize)

hadley