RE: [PHP] Php Enum Field

2002-02-18 Thread Rick Emery
Wee Chua Cc: [EMAIL PROTECTED] 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`");

Re: [PHP] Php Enum Field

2002-02-18 Thread Chris Lott
> 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.

RE: [PHP] Php Enum Field

2002-02-18 Thread Wee Chua
Sorry, my question was "how can I retrieve the preset Enum values from AccessRight field property?" Thanks. -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 2:51 PM To: 'Wee Chua'; PHP (E-mail) Subject: RE: [PHP] Php Enu

RE: [PHP] Php Enum Field

2002-02-18 Thread Rick Emery
I must not understand your question. As you've asked it, the answer is: SELECT AccessRight FROM tableA; -Original Message- From: Wee Chua [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 1:27 PM To: PHP (E-mail) Subject: [PHP] Php Enum Field Hi all, How can I get the p

[PHP] Php Enum Field

2002-02-18 Thread Wee Chua
Hi all, How can I get the preset values for Enum field inside the table. For example, table A has a field called AccessRight, the enum fields are "Read,Add,Delete". How can I write the query to get these values out from AccessRight field? Thanks, Wee -- PHP General Mailing List (http://www.php.