Hey, I've really been thinking about this lately.
Is there any way to put Arrays into MySQL, for example:

PHP Code:

$array[0] = "yes";
$array[1] = "no";

$sql = '`field` = '.$array.''; 


Currently I've never got it to work (If anything i get the word 'Array' back, but no values). So I end up using explodes, for example.

PHP Code:

$array = "yes|/|no";

$sql = '`field` = '.$array.'';

// do SQL, and receive it back as say...$hobbit.

$hobbit = explode($hobbit, "|/|"); 


You want to look at the php functions SERIALIZE and UNSERIALIZE

They basically convert the array to and from a string representation for purposes like this!

Originally Posted by Triexa

You want to look at the php functions SERIALIZE and UNSERIALIZE

They basically convert the array to and from a string representation for purposes like this!

Thank you ^^ This worked just the way i wanted it too

It's ok, 'Triexa' helped me. If you want to put an array into SQL you need to do something simlar to the following:

PHP Code:

$array[0] = "yes";
$array[1] = "no";

$sql = '`field` = '.serialize($array).''; 

// do SQL, and receive it back as say...$hobbit.
$hobbit['field'] = unserialize($hobbit['field']);