RE: [PHP-DB] reading arrays within a field from mysql and separating the values
the explode() should have worked on that. Something like:
$query = SELECT DCD_Access FROM userdb WHERE ID = $user_ID;
$result4 = mysql_query($query) or die(Error);
$DCD = mysql_fetch_array($result4);
$myarray = explode( ,, $DCD['DCD_Access'] );
foreach ( $myarray as $val )
{
print option value='$val'$val/option\n;
}
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 4:45 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
NASA, BBCI
I want to separate these but I either get what I show above as a single
value or the word Array depending on how I try to get to the values.
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
Newsgroups: php.db
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 4:27 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
Robert,
Do a manual SELECT DCD_Access FROM userdb WHERE ID = ###
and send the results. I'd like to see exactly what is in that field. The
explode() should have provided an array of values
rick
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:53 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
The same as my original message.
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
Newsgroups: php.db
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 3:40 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
what do you mean by it made no difference? Did you examine each element
in
$myarray? What were the results?
rick
FYI...I tried to send directly to you and the message was bounced back
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:30 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
Rick,
I tried it and it made no difference. Could you give me a more complete
example?
Thanks for the help.
Robert
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Robert Trembath' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 3:03 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
$myarray=explode(,,$DCD['DCD_Access']);
Then, cycle through each $myarray element as you've done below.
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 2:55 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] reading arrays within a field from mysql and
separating the values
Hello everyone,
Ran into a problem trying to get this to work. I have multiple names
in
a
mysql field (DCD_Access) that contains name1, name2, name3, name4
and
I
want read this information as an array so I can use these values to
populate
a pull-down list using a while or foreach loop. Below is the code I
used,
but I get the values as a single entry no matter what I try. This
query
brings a single result row name1, name2, name3, name4. Here's the
code:
$result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID =
'$user_ID');
$DCD = mysql_fetch_array ( $result4 );
print td width='6%' valign=top\n
div align='center'\n
select name='LCompare'\n
option value='none'None/option\n
option value='within'Within Gel/option\n;
foreach ( $DCD as $val )
{
print option value='$val'$val/option\n;
}
print/select/div\n
/td\n;
This returns HTML like:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
/select
/div /td
What I need is to get:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1'name1/option
option value='name2'name2/option
option value='name3'name3/option
option value='name4'name4/option
/select
/div /td
Anyone know how to fix this?
Robert
Re: [PHP-DB] reading arrays within a field from mysql and separating the values
$my_arr= array(.);
echo implode(' ',array_keys($my_arr));
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 11, 2001 4:23 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and separating the
values
the explode() should have worked on that. Something like:
$query = SELECT DCD_Access FROM userdb WHERE ID = $user_ID;
$result4 = mysql_query($query) or die(Error);
$DCD = mysql_fetch_array($result4);
$myarray = explode( ,, $DCD['DCD_Access'] );
foreach ( $myarray as $val )
{
print option value='$val'$val/option\n;
}
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 4:45 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
NASA, BBCI
I want to separate these but I either get what I show above as a single
value or the word Array depending on how I try to get to the values.
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
Newsgroups: php.db
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 4:27 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
Robert,
Do a manual SELECT DCD_Access FROM userdb WHERE ID = ###
and send the results. I'd like to see exactly what is in that field. The
explode() should have provided an array of values
rick
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:53 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
The same as my original message.
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
Newsgroups: php.db
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 3:40 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
what do you mean by it made no difference? Did you examine each element
in
$myarray? What were the results?
rick
FYI...I tried to send directly to you and the message was bounced back
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:30 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
Rick,
I tried it and it made no difference. Could you give me a more complete
example?
Thanks for the help.
Robert
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Robert Trembath' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 3:03 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
$myarray=explode(,,$DCD['DCD_Access']);
Then, cycle through each $myarray element as you've done below.
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 2:55 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] reading arrays within a field from mysql and
separating the values
Hello everyone,
Ran into a problem trying to get this to work. I have multiple names
in
a
mysql field (DCD_Access) that contains name1, name2, name3, name4
and
I
want read this information as an array so I can use these values to
populate
a pull-down list using a while or foreach loop. Below is the code I
used,
but I get the values as a single entry no matter what I try. This
query
brings a single result row name1, name2, name3, name4. Here's the
code:
$result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID =
'$user_ID');
$DCD = mysql_fetch_array ( $result4 );
print td width='6%' valign=top\n
div align='center'\n
select name='LCompare'\n
option value='none'None/option\n
option value='within'Within Gel/option\n;
foreach ( $DCD as $val )
{
print option value='$val'$val/option\n;
}
print/select/div\n
/td\n;
This returns HTML like:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
/select
Re: [PHP-DB] reading arrays within a field from mysql and separating the values
, ok, sorry for the disturbance. greets.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Andrey Hristov' [EMAIL PROTECTED]; Rick Emery [EMAIL PROTECTED]
Sent: Tuesday, September 11, 2001 4:39 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and separating the
values
yes, is corrrect concerning implode(), which constructs a string from an
array. He already has string, such as name1,name2,name3,name4. What he
wants is:
$array[0] = name1
$array[1] = name2
$array[2] = name3
$array[3] = name4
$array = explode(,, name1,name2,name3,name4 ) performs this
function
-Original Message-
From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 11, 2001 8:32 AM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
so implode(' ') separates the values with space. i use implode() many
times when using files. $content =
implode('',file('file_name'));
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Andrey Hristov' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, September 11, 2001 4:30 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
Andrey,
He wants to separate values from an array, not combine them into an array.
-Original Message-
From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 11, 2001 8:26 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
$my_arr= array(.);
echo implode(' ',array_keys($my_arr));
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 11, 2001 4:23 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
the explode() should have worked on that. Something like:
$query = SELECT DCD_Access FROM userdb WHERE ID = $user_ID;
$result4 = mysql_query($query) or die(Error);
$DCD = mysql_fetch_array($result4);
$myarray = explode( ,, $DCD['DCD_Access'] );
foreach ( $myarray as $val )
{
print option value='$val'$val/option\n;
}
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 4:45 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
NASA, BBCI
I want to separate these but I either get what I show above as a single
value or the word Array depending on how I try to get to the values.
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
Newsgroups: php.db
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 4:27 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
Robert,
Do a manual SELECT DCD_Access FROM userdb WHERE ID = ###
and send the results. I'd like to see exactly what is in that field.
The
explode() should have provided an array of values
rick
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:53 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
The same as my original message.
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
Newsgroups: php.db
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 3:40 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
what do you mean by it made no difference? Did you examine each
element
in
$myarray? What were the results?
rick
FYI...I tried to send directly to you and the message was bounced
back
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:30 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
Rick,
I tried it and it made no difference. Could you give me a more
complete
example?
Thanks for the help.
Robert
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Robert Trembath' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, September 10, 2001 3:03 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
$myarray=explode(,,$DCD['DCD_Access']);
Then, cycle through each
RE: [PHP-DB] reading arrays within a field from mysql and separating the values
$myarray=explode(,,$DCD['fieldname']);
In the above, substitute fieldname for the name of the field which
contains name1,name2,name3,name4,...
Then, cycle through each $myarray element as you've done below.
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 2:55 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] reading arrays within a field from mysql and
separating the values
Hello everyone,
Ran into a problem trying to get this to work. I have multiple names in a
mysql field (DCD_Access) that contains name1, name2, name3, name4 and I
want read this information as an array so I can use these values to populate
a pull-down list using a while or foreach loop. Below is the code I used,
but I get the values as a single entry no matter what I try. This query
brings a single result row name1, name2, name3, name4. Here's the code:
$result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID =
'$user_ID');
$DCD = mysql_fetch_array ( $result4 );
print td width='6%' valign=top\n
div align='center'\n
select name='LCompare'\n
option value='none'None/option\n
option value='within'Within Gel/option\n;
foreach ( $DCD as $val )
{
print option value='$val'$val/option\n;
}
print/select/div\n
/td\n;
This returns HTML like:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1, name2, name3, name4'name1, name2, name3,
name4/option
option value='name1, name2, name3, name4'name1, name2, name3,
name4/option
option value='name1, name2, name3, name4'name1, name2, name3,
name4/option
option value='name1, name2, name3, name4'name1, name2, name3,
name4/option
/select
/div /td
What I need is to get:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1'name1/option
option value='name2'name2/option
option value='name3'name3/option
option value='name4'name4/option
/select
/div /td
Anyone know how to fix this?
Robert
--
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]
RE: [PHP-DB] reading arrays within a field from mysql and separating the values
$myarray=explode(,,$DCD['DCD_Access']);
Then, cycle through each $myarray element as you've done below.
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 2:55 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] reading arrays within a field from mysql and
separating the values
Hello everyone,
Ran into a problem trying to get this to work. I have multiple names in a
mysql field (DCD_Access) that contains name1, name2, name3, name4 and I
want read this information as an array so I can use these values to populate
a pull-down list using a while or foreach loop. Below is the code I used,
but I get the values as a single entry no matter what I try. This query
brings a single result row name1, name2, name3, name4. Here's the code:
$result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID =
'$user_ID');
$DCD = mysql_fetch_array ( $result4 );
print td width='6%' valign=top\n
div align='center'\n
select name='LCompare'\n
option value='none'None/option\n
option value='within'Within Gel/option\n;
foreach ( $DCD as $val )
{
print option value='$val'$val/option\n;
}
print/select/div\n
/td\n;
This returns HTML like:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1, name2, name3, name4'name1, name2, name3,
name4/option
option value='name1, name2, name3, name4'name1, name2, name3,
name4/option
option value='name1, name2, name3, name4'name1, name2, name3,
name4/option
option value='name1, name2, name3, name4'name1, name2, name3,
name4/option
/select
/div /td
What I need is to get:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1'name1/option
option value='name2'name2/option
option value='name3'name3/option
option value='name4'name4/option
/select
/div /td
Anyone know how to fix this?
Robert
--
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]
RE: [PHP-DB] reading arrays within a field from mysql and separating the values
what do you mean by it made no difference? Did you examine each element in
$myarray? What were the results?
rick
FYI...I tried to send directly to you and the message was bounced back
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:30 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
Rick,
I tried it and it made no difference. Could you give me a more complete
example?
Thanks for the help.
Robert
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Robert Trembath' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 3:03 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
$myarray=explode(,,$DCD['DCD_Access']);
Then, cycle through each $myarray element as you've done below.
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 2:55 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] reading arrays within a field from mysql and
separating the values
Hello everyone,
Ran into a problem trying to get this to work. I have multiple names in a
mysql field (DCD_Access) that contains name1, name2, name3, name4 and I
want read this information as an array so I can use these values to
populate
a pull-down list using a while or foreach loop. Below is the code I used,
but I get the values as a single entry no matter what I try. This query
brings a single result row name1, name2, name3, name4. Here's the code:
$result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID =
'$user_ID');
$DCD = mysql_fetch_array ( $result4 );
print td width='6%' valign=top\n
div align='center'\n
select name='LCompare'\n
option value='none'None/option\n
option value='within'Within Gel/option\n;
foreach ( $DCD as $val )
{
print option value='$val'$val/option\n;
}
print/select/div\n
/td\n;
This returns HTML like:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
/select
/div /td
What I need is to get:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1'name1/option
option value='name2'name2/option
option value='name3'name3/option
option value='name4'name4/option
/select
/div /td
Anyone know how to fix this?
Robert
--
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]
--
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]
RE: [PHP-DB] reading arrays within a field from mysql and separating the values
Robert,
Do a manual SELECT DCD_Access FROM userdb WHERE ID = ###
and send the results. I'd like to see exactly what is in that field. The
explode() should have provided an array of values
rick
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:53 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
The same as my original message.
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
Newsgroups: php.db
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 3:40 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
what do you mean by it made no difference? Did you examine each element
in
$myarray? What were the results?
rick
FYI...I tried to send directly to you and the message was bounced back
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:30 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
Rick,
I tried it and it made no difference. Could you give me a more complete
example?
Thanks for the help.
Robert
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Robert Trembath' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 3:03 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
$myarray=explode(,,$DCD['DCD_Access']);
Then, cycle through each $myarray element as you've done below.
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 2:55 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] reading arrays within a field from mysql and
separating the values
Hello everyone,
Ran into a problem trying to get this to work. I have multiple names in
a
mysql field (DCD_Access) that contains name1, name2, name3, name4 and
I
want read this information as an array so I can use these values to
populate
a pull-down list using a while or foreach loop. Below is the code I
used,
but I get the values as a single entry no matter what I try. This query
brings a single result row name1, name2, name3, name4. Here's the
code:
$result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID =
'$user_ID');
$DCD = mysql_fetch_array ( $result4 );
print td width='6%' valign=top\n
div align='center'\n
select name='LCompare'\n
option value='none'None/option\n
option value='within'Within Gel/option\n;
foreach ( $DCD as $val )
{
print option value='$val'$val/option\n;
}
print/select/div\n
/td\n;
This returns HTML like:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
option value='name1, name2, name3, name4'name1, name2,
name3,
name4/option
/select
/div /td
What I need is to get:
td width='6%' valign=top
div align='center'
select name='LCompare'
option value='none'None/option
option value='within'Within Gel/option
option value='name1'name1/option
option value='name2'name2/option
option value='name3'name3/option
option value='name4'name4/option
/select
/div /td
Anyone know how to fix this?
Robert
--
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]
--
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]
