Re: [PHP] newbie PHP/HTML pull down menu problem

[Justin French]

You have a while loop that pulls values out of the MySQL table row by row,
and for each row, you output an option in the select box.

Something like:

form name=tester action=script.php method=get
select name=color
?
$sql = SELECT color_id, color FROM colors_table ORDER BY id;
$result = mysql_query($sql);
while($myrow = mysql_fetch_array($result))
{
$color_id = $myrow['color_id'];
$color = $myrow['color']
echo option value=\{$color_id}\{$color}/option;
}
?
/select
/form


Season to taste :)
Justin French



on 14/08/02 2:30 PM, Brian  Shannon Windsor ([EMAIL PROTECTED])
wrote:

 Hi,
 
 I want to pull information out of my mySQL database and use it as a pull
 down menu ona web page.  There are two sets of information that I need, one
 is a color, and the other is the color_id, so I want to use it in the way
 below but without having to physically enter all the data.  I'd like to use
 color_id as the value and the actual color name as the text in the pull down
 button.  Can someone please help me on how to pass the info into a useable
 way to get the info out of PHP and into HTML?  I've haad no problems going
 from HTML to PHP, but can't seem to grasp going the other way, especially
 with a list of things.  I've been banging my head against this for two days,
 but something tells me it's extremely easy.
 
 Thanks,
 
 Brian
 
 form name=tester action=script.php method=get
 select name=color
 option value=1red
 option value=2blue
 option value=3black
 option value=4ice
 option value=5purple
 /select
 /form
 
 
 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] newbie PHP/HTML pull down menu problem

[Brian Shannon Windsor]

Hi,

I want to pull information out of my mySQL database and use it as a pull
down menu ona web page.  There are two sets of information that I need, one
is a color, and the other is the color_id, so I want to use it in the way
below but without having to physically enter all the data.  I'd like to use
color_id as the value and the actual color name as the text in the pull down
button.  Can someone please help me on how to pass the info into a useable
way to get the info out of PHP and into HTML?  I've haad no problems going
from HTML to PHP, but can't seem to grasp going the other way, especially
with a list of things.  I've been banging my head against this for two days,
but something tells me it's extremely easy.

Thanks,

Brian

form name=tester action=script.php method=get
 select name=color
  option value=1red
  option value=2blue
  option value=3black
  option value=4ice
  option value=5purple
 /select
/form




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] newbie PHP/HTML pull down menu problem

[@ Edwin]

Something like this should work:

  after mysql_connect() and mysql_select_db() ...
  
  $sql = "SELECT color_id,color FROM mytable";
  $result = mysql_query($sql);
  echo 'form blah,blah,blah';
  echo 'select name="color_id"';
  while ($row = mysql_fetch_array($result)){
printf("option value=\"%s\"",$row["color_id"]);
printf("%s/option",$row["color"]);
  }
  echo '/select';
  echo '/form';

HTH,

- E

PS
Check the manual for printf() if you're not sure how it works...

  http://www.php.net/manual/en/function.printf.php




Hi,

I want to pull information out of my mySQL database and use it as a pull
down menu ona web page.  There are two sets of information that I need, 
one
is a color, and the other is the color_id, so I want to use it in the way
below but without having to physically enter all the data.  I'd like to 
use
color_id as the value and the actual color name as the text in the pull 
down
button.  Can someone please help me on how to pass the info into a useable
way to get the info out of PHP and into HTML?  I've haad no problems going
from HTML to PHP, but can't seem to grasp going the other way, especially
with a list of things.  I've been banging my head against this for two 
days,
but something tells me it's extremely easy.

Thanks,

Brian

form name="tester" action="script.php" method="get"
  select name="color"
   option value="1"red
   option value="2"blue
   option value="3"black
   option value="4"ice
   option value="5"purple
  /select
/form




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




_
$B$-$C$H8+$D$+$k$"$J$?$N?75o!!ITF0;:>pJs$O(B MSN $B=;Bp$G(B http://house.msn.co.jp/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php