Getting the SET values from MySQL field

[palpie]

I have a table with a SET field in it. It has, for example, three settings "one", "two" and "three".

Now I want to get those three into variables or, preferably, an array.

How do I do this?

[kostik]

CREATE TABLE test (
id tinyint(4) DEFAULT '0' NOT NULL,
lala set('one','two','three') NOT NULL
);

INSERT INTO test VALUES '1', 'one,two,three');

$result = mysql_query("SELECT lala FROM test WHERE id='1'");

$row = mysql_fetch_array($result);

$theArray = explode(",", $row['lala']);

echo $theArray[0];
echo $theArray[1];
echo $theArray[2];
....

Now you have all vars in the array $theArray.

[palpie]

Well, that was not exaclty what I asked for. I wanted the properties for the set type field which you called lala. I solved it with the SQL command "SHOW COLUMNS FROM table".

But thanks anyway 🙂