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.
<[EMAIL PROTECTED]>:
ezmlm-manage: fatal: message already has a Mailing-List header (maybe I should be a
sublist) (#5.7.2)
<[EMAIL PROTECTED]>:
confirm unsubscribe from [EMAIL PROTECTED]: 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: <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
Received: from toye.php.net ([198.186.203.51]) by vespasian.mspring.net (Mindspring
Mail Service) with SMTP id t6uneg.j1o.37kbpqe for <[EMAIL PROTECTED]>; Wed, 24
Jan 2001 17:57:20 -0500 (EST)
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Received: (qmail 19119 invoked by uid 1013); 24 Jan 2001 22:54:49 -0000
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
List-Help: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <mailto:[EMAIL PROTECTED]>
Date: Wed, 24 Jan 2001 17:04:03 -0800
Message-ID: <[EMAIL PROTECTED]>
Content-Transfer-Encoding: quoted-printable
Delivered-To: responder for [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>; 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 [EMAIL PROTECTED]
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
I'm working for my owner, who can be reached
at [EMAIL PROTECTED]
To confirm that you would like
[EMAIL PROTECTED]
removed from the php-db mailing list, please send an empty reply=20
to this address:
=
[EMAIL PROTECTED]=
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, [EMAIL PROTECTED] receives messages
with return path: =
<php-db-return-<number>[EMAIL PROTECTED]
Some mail programs are broken and cannot handle long addresses. If you
cannot reply to this request, instead send a message to
<[EMAIL PROTECTED]> 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:
<[EMAIL PROTECTED]>
To remove your address from the list, send a message to:
<[EMAIL PROTECTED]>
Send mail to the following for info and FAQ for this list:
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
Similar addresses exist for the digest list:
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
To get messages 123 through 145 (a maximum of 100 per request), mail:
<[EMAIL PROTECTED]>
To get an index with subject and author for messages 123-456 , mail:
<[EMAIL PROTECTED]>
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:
<[EMAIL PROTECTED]>
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 "[EMAIL PROTECTED]", just add a hyphen and your
address (with '=3D' instead of '@') after the command word:
<[EMAIL PROTECTED]>
To stop subscription for this address, mail:
<[EMAIL PROTECTED]>
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
[EMAIL PROTECTED] Please be patient, my owner is a
lot slower than I am ;-)
--- Enclosed is a copy of the request I received.
Return-Path: <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Received: from toye.php.net ([198.186.203.51]) by antoninus (Mindspring =
Mail Service) with SMTP id t6u4mr.hi5.37kbpq6 for =
<[EMAIL PROTECTED]>; 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.
<[EMAIL PROTECTED]>:
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: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>; Wed, 24 Jan 2001 09:37:28 -0800 =
=3D
(PST)
From: "Mike" <[EMAIL PROTECTED]>
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
<[EMAIL PROTECTED]>; Tue, 21 Nov 2000 12:11:56 -0500 (EST)
To: <[EMAIL PROTECTED]>
Received: (qmail 20675 invoked by uid 1013); 21 Nov 2000 17:10:09 -0000
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Precedence: bulk
list-help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
list-post: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
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: <[EMAIL PROTECTED]>
Addressed to: John Guynn <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from John Guynn <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
