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:



{$color}";
}
?>




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
> 
> 
> 
> red
> blue
> black
> ice
> purple
> 
> 
> 
> 
> 


-- 
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 '';
  echo '';
  while ($row = mysql_fetch_array($result)){
printf("",$row["color_id"]);
printf("%s",$row["color"]);
  }
  echo '';
  echo '';

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
>
>
>  
>   red
>   blue
>   black
>   ice
>   purple
>  
>
>
>
>
>
>--
>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