Will there ever be 5 specials categories? 6?
I like enums for strings, but for more complex sites I go with a separate
table for even 4 categories. I don't actually know what happens if you
change "lunch" to "pre-dinner" on the enum column -- does everything remain
as enum selection #1 and chang
To: "Becoming Digital" <[EMAIL PROTECTED]>; "PHP-DB"
<[EMAIL PROTECTED]>
Sent: Monday, 02 June, 2003 06:40
Subject: Re: [PHP-DB] Dealing with ENUM fields
What's the application? What are the issues with using ENUM verses
something else?
-Lisi
At 05:32 AM 6/2/0
t;> From: "heilo" <[EMAIL PROTECTED]>
>> To: "PHP-DB" <[EMAIL PROTECTED]>
>> Sent: Monday, 02 June, 2003 05:11
>> Subject: Re: [PHP-DB] Dealing with ENUM fields
>>
>>
>> Hi!
>>
>> there is a much shorter way to d
d for
this application?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "heilo" <[EMAIL PROTECTED]>
To: "PHP-DB" <[EMAIL PROTECTED]>
Sent: Monday, 02 June, 2003 05:11
Subject: Re: [PHP-DB] Dealing with ENUM fields
Hi!
t
ROTECTED]>
To: "PHP-DB" <[EMAIL PROTECTED]>
Sent: Monday, 02 June, 2003 05:11
Subject: Re: [PHP-DB] Dealing with ENUM fields
Hi!
there is a much shorter way to do this (which works with ENUM and SET):
$qry = 'SHOW COLUMNS FROM `gruzilla_content` LIKE "module"
Hi!
there is a much shorter way to do this (which works with ENUM and SET):
$qry = 'SHOW COLUMNS FROM `gruzilla_content` LIKE "module"';
$res = mysql_query($qry);
if(mysql_num_rows($res)>0)
{
$row = mysql_fetch_row($res);
$pattern = "#(enum|set)\('(.+?)'\)#i";
$replace = '\\2';
$
I am forwarding this useful function someone once sent to the list that I
use often.
Hope this fits your needs.
-Lisi
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002 7:47 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Popula
I have a field in my database for which there are only four potential values
and, as such, I would like to use an ENUM field. However, I can't find an easy
way to load the "values" of this field into a select form element. Is there a
simple method for doing this or are the only solutions fairly c
