Re: [PHP] get emum values

2002-02-24 Thread Jason Wong
On Monday 25 February 2002 02:59, Nick Wilson wrote: Hi all Which php function can I use to get the emum values from a mysql db table? I remember doing this once before but I've been looking at the manual and just can't remember how I did it? Not sure whether there is a built-in function for

Re: [PHP] get emum values

2002-02-24 Thread Matt
I think I got this off the Zend site a year or so ago: // function mysql_fetch_enumerations($db_connection, $table_name, $column_name, $sorted=unsorted) { /* Author Thomas J. Swan Revision History 1.0Creation of function 1.1Added the ability to sort the array before returning

Re: [PHP] get emum values

2002-02-24 Thread Nick Wilson
-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