Re: get emum values

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 * and then Jason Wong declared.... > Not sure whether there is a built-in function for doing so. But here's > something I prepared earlier: > > function create_list_from_ENUM($dbh, $table, $column) { > $sth = $dbh->prepare("SHOW COLUMNS FROM $table LIKE '$column'"); > if ($sth) { > $sth->execute(); > while ($row = $sth->fetchrow_hash()) { > ereg("('(.*)')", $row[1], $temp); > $array = explode( "','", $temp[2] ); > while (list ($key, $val) = each ($array)) { > $return[] = "$val"; > } > } > } > return $return; > } Yep, It's come back to me now. Your right of course there is no php function for this, it's the 'show columns' sql that does the trick. Cheers! - -- - ----------------------------------------------------------- www.explodingnet.com | Projects, Forums and + Articles for website owners - -- Nick Wilson -- | and designers. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8eT6kHpvrrTa6L5oRAkQ3AJkB9oYyoidJUlfyUF9LZYe0nUh/rACdGOUj LkdsHqhrHequJVuhKGi/HLM= =hbeU -----END PGP SIGNATURE-----