RE: [PHP] Php Enum Field
| From: | Rick Emery | Date: | Mon, 18 Feb 2002 20:21:07 +0000 |
| Subject: | RE: [PHP] Php Enum Field | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-85274@lists.php.net to get a copy of this message | ||
mysql> show columns from mytable like "myfield";
+-------+-----------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-----------------------------+------+-----+---------+-------+
| myfield | enum('Add','Read','Delete') | YES | | NULL |
|
+-------+-----------------------------+------+-----+---------+-------+
1 row in set (0.00 sec)
-----Original Message-----
From: Chris Lott [mailto:chrisl@frodo.thethirdsector.com]
Sent: Monday, February 18, 2002 2:10 PM
To: Wee Chua
Cc: php-general@lists.php.net
Subject: Re: [PHP] Php Enum Field
> Sorry, my question was "how can I retrieve the preset Enum values from
> AccessRight field property?" Thanks.
Untested, but I think I remember:
$result = mysql_query("SHOW COLUMNS FROM main LIKE
colname");
c
--
Chris Lott
http://www.chrislott.org/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php