failure notice

Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <php-db-unsubscribe@lists.php.net>: ezmlm-manage: fatal: message already has a Mailing-List header (maybe I should be a sublist) (#5.7.2) <php-db@lists.php.net>: confirm unsubscribe from php-db@lists.php.netezmlm-send: fatal: message already has a Mailing-List header (maybe I should be a sublist) (#5.7.2) --- Below this line is a copy of the message. Return-Path: <Mike@valves-source.com> Received: (qmail 9500 invoked from network); 25 Jan 2001 01:00:14 -0000 Received: from unknown (HELO gull.prod.itd.earthlink.net) (207.217.121.85) by va.php.net with SMTP; 25 Jan 2001 01:00:14 -0000 Received: from michaelbowman (sdn-ar-002orportP225.dialsprint.net [63.178.64.241]) by gull.prod.itd.earthlink.net (EL-8_9_3_3/8.9.3) with SMTP id RAA22261; Wed, 24 Jan 2001 17:02:39 -0800 (PST) From: "Mike" <Mike@valves-source.com> Received: from toye.php.net ([198.186.203.51]) by vespasian.mspring.net (Mindspring Mail Service) with SMTP id t6uneg.j1o.37kbpqe for <Mike@valves-source.com>; Wed, 24 Jan 2001 17:57:20 -0500 (EST) To: <php-db-unsubscribe@lists.php.net>, <php-db@lists.php.net> Received: (qmail 19119 invoked by uid 1013); 24 Jan 2001 22:54:49 -0000 Mailing-List: contact php-db-help@lists.php.net; run by ezmlm List-Help: <mailto:php-db-help@lists.php.net> List-Post: <mailto:php-db@lists.php.net> List-Subscribe: <mailto:php-db-subscribe@lists.php.net> Date: Wed, 24 Jan 2001 17:04:03 -0800 Message-ID: <980376889.19117.ezmlm@lists.php.net> Content-Transfer-Encoding: quoted-printable Delivered-To: responder for php-db@lists.php.net Received: (qmail 19105 invoked from network); 24 Jan 2001 22:54:48 -0000 Received: from unknown (HELO scaup.prod.itd.earthlink.net) (207.217.121.49) by va.php.net with SMTP; 24 Jan 2001 22:54:48 -0000 Received: from michaelbowman (sdn-ar-012orportP142.dialsprint.net [63.180.14.206]) by scaup.prod.itd.earthlink.net (EL-8_9_3_3/8.9.3) with SMTP id OAA15602; Wed, 24 Jan 2001 14:57:10 -0800 (PST) X-Mailer: Microsoft Outlook Express 5.50.4522.1200 Received: from toye.php.net ([198.186.203.51]) by antoninus (Mindspring Mail Service) with SMTP id t6u4mr.hi5.37kbpq6 for <Mike@valves-source.com>; Wed, 24 Jan 2001 12:37:30 -0500 (EST) Received: (qmail 27563 invoked for bounce); 24 Jan 2001 17:35:02 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Subject: confirm unsubscribe from php-db@lists.php.net X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Hi! This is the ezmlm program. I'm managing the php-db@lists.php.net mailing list. I'm working for my owner, who can be reached at php-db-owner@lists.php.net. To confirm that you would like Mike@valves-source.com removed from the php-db mailing list, please send an empty reply=20 to this address: = php-db-uc.980376889.fmpafiidpfnnpmhjfink-Mike=3Dvalves-source.com@lists..p= hp.net Usually, this happens when you just hit the "reply" button. If this does not work, simply copy the address and paste it into the "To:" field of a new message. or click here: = mailto:php-db-uc.980376889.fmpafiidpfnnpmhjfink-Mike=3Dvalves-source.com@= lists.php.net I haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, mary@xdd.ff.com receives messages with return path: = <php-db-return-<number>-mary=3Dxdd.ff.com@lists.php.net. Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to <php-db-request@lists.php.net> and put the entire address listed above into the "Subject:" line. --- Administrative commands for the php-db list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: <php-db-subscribe@lists.php.net> To remove your address from the list, send a message to: <php-db-unsubscribe@lists.php.net> Send mail to the following for info and FAQ for this list: <php-db-info@lists.php.net> <php-db-faq@lists.php.net> Similar addresses exist for the digest list: <php-db-digest-subscribe@lists.php.net> <php-db-digest-unsubscribe@lists.php.net> To get messages 123 through 145 (a maximum of 100 per request), mail: <php-db-get.123_145@lists.php.net> To get an index with subject and author for messages 123-456 , mail: <php-db-index.123_456@lists.php.net> They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: <php-db-thread.12345@lists.php.net> The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example "john@host.domain", just add a hyphen and your address (with '=3D' instead of '@') after the command word: <php-db-subscribe-john=3Dhost.domain@lists.php.net> To stop subscription for this address, mail: <php-db-unsubscribe-john=3Dhost.domain@lists.php.net> In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at php-db-owner@lists.php.net. Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: <Mike@valves-source.com> Received: (qmail 19105 invoked from network); 24 Jan 2001 22:54:48 -0000 Received: from unknown (HELO scaup.prod.itd.earthlink.net) = (207.217.121.49) by va.php.net with SMTP; 24 Jan 2001 22:54:48 -0000 Received: from michaelbowman (sdn-ar-012orportP142.dialsprint.net = [63.180.14.206]) by scaup.prod.itd.earthlink.net (EL-8_9_3_3/8.9.3) with SMTP id = OAA15602; Wed, 24 Jan 2001 14:57:10 -0800 (PST) From: "Mike" <Mike@valves-source.com> To: <php-db-unsubscribe@lists.php.net>, <php-db@lists.php.net> Received: from toye.php.net ([198.186.203.51]) by antoninus (Mindspring = Mail Service) with SMTP id t6u4mr.hi5.37kbpq6 for = <Mike@valves-source.com>; Wed, 24 Jan 2001 12:37:30 -0500 (EST) Received: (qmail 27563 invoked for bounce); 24 Jan 2001 17:35:02 -0000 Date: Wed, 24 Jan 2001 14:58:09 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset=3D"iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook Express 5.50.4522.1200 Subject: failure notice Message-ID: <200101241237.t6u4mr.hi5.37kbpq6@antoninus> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following =3D addresses. This is a permanent error; I've given up. Sorry it didn't work out. <php-db-unsubscribe@lists.php.net>: ezmlm-manage: fatal: message already has a Mailing-List header (maybe I = =3D should be a sublist) (#5.7.2) --- Below this line is a copy of the message. Return-Path: <Mike@valves-source.com> Received: (qmail 27556 invoked from network); 24 Jan 2001 17:35:01 -0000 Received: from unknown (HELO snipe.prod.itd.earthlink.net) =3D (207.217.120.62) by va.php.net with SMTP; 24 Jan 2001 17:35:01 -0000 Received: from michaelbowman (sdn-ar-011orportP206.dialsprint.net =3D [63.180.14.118]) by snipe.prod.itd.earthlink.net (EL-8_9_3_3/8.9.3) with SMTP id =3D JAA19084 for <php-db-unsubscribe@lists.php.net>; Wed, 24 Jan 2001 09:37:28 -0800 = =3D (PST) From: "Mike" <Mike@valves-source.com> Received: from toye.php.net ([198.186.203.33]) by vespasian.mspring.net = =3D (Mindspring Mail Service) with SMTP id t1lb6s.ebe.37kbpqe for =3D <Mike@valves-source.com>; Tue, 21 Nov 2000 12:11:56 -0500 (EST) To: <php-db-unsubscribe@lists.php.net> Received: (qmail 20675 invoked by uid 1013); 21 Nov 2000 17:10:09 -0000 Mailing-List: contact php-db-help@lists.php.net; run by ezmlm Precedence: bulk list-help: <mailto:php-db-help@lists.php.net> List-Unsubscribe: <mailto:php-db-unsubscribe@lists.php.net> list-post: <mailto:php-db@lists.php.net> Delivered-To: mailing list php-db@lists.php.net Received: (qmail 20664 invoked from network); 21 Nov 2000 17:10:08 -0000 X-Priority: 3 X-MSMail-Priority: Normal Priority: Normal MIME-Version: 1.0 Content-Type: text/plain; charset=3D3D"ISO-8859-1" X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook Express 5.50.4522.1200 Date: Wed, 24 Jan 2001 09:39:06 -0800 Subject: Re: [PHP-DB] Get all the enum values from a Mysql column? Message-ID: <200011211211.t1lb6s.ebe.37kbpqe@vespasian.mspring.net> Addressed to: John Guynn <John.Guynn@telescan.com> php-db@lists.php.net ** Reply to note from John Guynn <John.Guynn@telescan.com> Tue, 21 Nov = =3D 2000=3D3D 10:32:43 -0600 > =3D20 > Is there an easy way to get all the enum values from a column? > =3D20 > For example I have an enum column with the values > "Astro","Camaro","Firehawk","Neon" and I would like to > pull those =3D values > out to put in as <option>s in a html form with <select>. > =3D20 > I've read the mysql maunal about pulling all the values from and enum > column, "If you want to get all possible values for an ENUM column, = =3D you > should use: SHOW COLUMNS FROM table_name LIKE enum_column_name and =3D parse > the ENUM definition in the second column." For some reason I can't =3D make > heads or tails of this. Do you have access to command line MySQL? If so, the first thing to do = =3D is fire it up and try a query or two till you get something that works. For example, I have a table Types, that includes an enum field Free. = =3D I would get the possible values for Free like this: SHOW COLUMNS FROM Types LIKE 'Free'; This returns: +-------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+-------+ | Free | enum('No','Yes') | Yes | | Null | | +-------+------------------+------+-----+---------+-------+ As you can see, the second column contains the vaules, and some extra stuff. The trick is to parse the values out of the junk... Once you get a query that returns the desired results in the MySQL interpreter, you can convert it to PHP. $Result =3D3D3D mysql_query( "SHOW COLUMNS FROM Types LIKE 'Free'" ); while( list( $Field, $Type, $Null, $Key, $Default, $Extra )=3D20 =3D3D3D mysql_fetch_row( $Result )) { list( $junk, $Type ) =3D3D3D explode( '(', $Type );=3D20 # Type is now 'No','Yes') list( $Type ) =3D3D3D explode( ')', $Type ); # Type is now 'No','Yes' $Type =3D3D3D str_replace( "'", '', $Type ); # Type is now No,Yes $Types =3D3D3D explode( ',', $Type ); # Types is now an array containing the values allowed for the enum. # $Types[0] =3D3D3D No $Types[1] =3D3D3D 'Yes' } mysql_free_result( $Result ); This may not be the the easiest or best way to parse the data, but it should work. I have not actually tried it... =3D20 Using a while may seem unusual when I already know there should only be = =3D one row returned, but I use it because it will not throw an error message or warning if no rows are returned. =3D20 Rick Widmer Internet Marketing Specialists www.developersdesk.com --=3D20 PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net