what is it called when one record stores many values like "2,3,4,5,10" ?

[bradsears]

Mist, I appreciate the help. A friend of mine just sent me the text below as well so I think I am pointed in the right direction.

***********
Would you believe that I'd just coded something similar a few days ago?

There's a couple choices you could make. You can keep the data as a string and then do things like "strpos" to see if a number is in there, but that gets messy when you want to remove a number. Or you can turn the string in to an array, but then you have to translate it from a string to an array, and back again when you want to store it.

Here's a bit of code I had to do the array bit:

// $info is the comma string
function string2array($string) {
$temp = explode(",", $string);
$info = array();
foreach ($temp as $key) {
if ($key > 0)
$info[$key] = 1;
}
return $info;
}

And then you just need to look at $info[$X] to see if a particular number is set or not. To add/remove a number, just do $info[$X] = 1 or 0;

To get a lists of all the numbers (instead of just checking if they're
set) do

foreach ($info as $key => $value)
if ($value == 1) // needed if you're setting things to 0
echo "$key is one of the numbers set, yay.";

To turn it back in to a string,

function array2string($info) {
$string = "";
foreach ($info as $key => $value) {
$string .= "$key,";
}
return $string; // we have an extra "," at the end, might screw up vBulletin, so you could remove it with substr($string, -1) }
****************