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?

[Anon]

sdassdfsdfsdfdfsdfsdsdf

[trellie]

You can compare the SET column from mysql qith a bitmask.

So you'll have to use logical operators either in your sql statement or in you php script to find out wich elements from the SET are true and wich not...

[ccgorman]

Mads is obviously out of work.

$table_def = mysql_db_query("$database", "SHOW FIELDS FROM $table");
$row_table_def = mysql_fetch_array($table_def);

$set = str_replace("set(", "", $row_table_def["Type"]);
$set = ereg_replace("\)$", "", $set);
$set = ereg_replace("'", "", $set);
$set_array = explode(",",$set);

for ($i=0;$i<count($set_array);$i++) {
	PRINT($set_array[$i] . "<BR>");
}