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

2002-08-14 Thread 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

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

2002-08-13 Thread @ 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"]);

[PHP] newbie PHP/HTML pull down menu problem

2002-08-13 Thread 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 t