Re: Dealing with ENUM fields

This is for another menu project that I'm working on. The restaurant has a large list of daily specials, all of which fit into one of four categories (lunch, dinner, pizza, dessert). Because the data will never mix (no need for joins or unions), I wanted to keep the specials categories separate from the regular menu item categories. Because there are only four specials categories and they are static, I thought ENUM would work best. Your opinions? Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Lisi" <lists@shemeshdirectory.co.il> To: "Becoming Digital" <subs@becomingdigital.com>; "PHP-DB" <php-db@lists.php.net> 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/03 -0400, Becoming Digital wrote: >Thanks to both Heilo and Lisi. These scripts should make things easier. > >Is it safe to assume that we are in agreement about the use of an ENUM >field for >this application? > >Edward Dudlik >Becoming Digital >www.becomingdigital.com > > >----- Original Message ----- >From: "heilo" <grillen@abendstille.at> >To: "PHP-DB" <php-db@lists.php.net> >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"'; >$res = mysql_query($qry); >if(mysql_num_rows($res)>0) >{ > $row = mysql_fetch_row($res); > $pattern = "#(enum|set)\('(.+?)'\)#i"; > $replace = '\\2'; > $row[1] = preg_replace($pattern, $replace, $row[1]); > $options = explode("','", $row[1]); >} > >$options now contains every value of the enum. I think there is also a >possibility to do this within a query - but currently i do not find the >script on my HD.... :) - so this is a nice workaround! > >.ma > > >Lisi <lists@shemeshdirectory.co.il> wrote@02.06.2003 11:53 Uhr: > > > 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:russ@itomic.dns2go.com] > >> Sent: Wednesday, June 26, 2002 7:47 PM > >> To: NIPP, SCOTT V (SBCSI); php-db@lists.php.net > >> Subject: RE: [PHP-DB] Populating a dropdown list with ENUM values... > >> > >> > >> G'day Scott: > >> > >> I wrote this function to do just what you're atfer: > >> You may need to mess with it for you're own needs - but go for your > >> life! > >> > >> //----function: "enum_select()" - automatically generate an HTML select > >> menu from a MySQL ENUM field > >> //----1). takes a table name: '$table' > >> //----2). a name for the menu '$name' > >> //----3). a CSS class > >> function enum_select($table,$name,$class) { > >> $sql = "SHOW COLUMNS FROM $table"; > >> $result = mysql_query($sql); > >> $select = "<select name=\"$name\" > >> class=\"$class\">\n\t"; > >> while($myrow = mysql_fetch_row($result)){ > >> $enum_field = substr($myrow[1],0,4); > >> if($enum_field == "enum"){ > >> global $enum_field; > >> $enums = substr($myrow[1],5,-1); > >> $enums = > >> ereg_replace("'","",$enums); > >> $enums = explode(",",$enums); > >> foreach($enums as $val) { > >> $select .= "<option > >> value=\"$val\">$val</option>\n\t"; > >> }//----end foreach > >> }//----end if > >> }//----end while > >> $select .= "\r</select>"; > >> return $select; > >> }//----end function > >> > >> > >> All the best. > >> Russ > >> > >> -- > >> PHP Database Mailing List (http://www.php.net/) > >> To unsubscribe, visit: http://www.php.net/unsub.php > > > >Matthias Steinböck >Email: grillen@abendstille.at >Web: http://www.abendstille.at > >Frühabendliches Webdesign. >------------------------------------------ >Im Übrigen sind wir der Meinung, dass >unsere Gesellschaft Gabel-diskriminierend >Löffel verwendet. Alle Macht den Gabeln! > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php