forms select box

[Anon]

with an php/sql form, i know how to echo back a text form field:

<input type="text" name="city" value="<?php echo $city ?>">

and i've found lots of examples on multiple choice lists using arrays to access the choices, but how do i echo back a select menu? like this:

<select name="age">
<option> </option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
</select>

[leatherback]

Try the following, where $sql_query is the query you have set up to get the menu-options, and Whatever is oe of the tablefields you have taken data from to be in the select options. (BTW: I seem to recall there being a tutorial on building dynamic form element on this website...):

$resultArr = mysql_query($sql_query)

while ($row =@ mysql_fetch_array($ResultArr))

{
$SelectOptions .= "<Option value= $row[Whatever]> $row[Whatever]</option>
";

}

---

<select name="tryMe">
<? echo $SelectOptions ?>
</select>

Good luck,

J.

[Anon]

thanks. i am not using an array to build the form. it's just html, using php to echo the values. i think i can use an if statement, but for select menus that have 100 <option>'s, it's too much manual labor. maybe i'm going about this wrong?

[Anon]

Hmmm, i hope i got your point - if yes, you can use a while loop (if you have a fixed number of options) with a counter...eg.:

<select name="age">
<?
$counter = 0;
while ($counter < 100) { ?>
<option value="<? echo $counter ?>"><? echo $counter ?></option>
<? $counter++;
} ?>
</select>

greetz 🙂

[kasonde]

I thought when you are úsing the select option, you assign the values at the end of ech option row. what values do u want to echo? or may be you mean something like this:
echo " <tr>";
echo "<td> select message:<select name="" value = "$var">
echo "<option value= "valuename"> </option>;
.
.
.
Hope this is what you are looking for.

[Anon]

that came in handy for an age selection, where it's numbers, but what if it's not a number? -thanks

[Anon]

It doesn't matter ehat you are selecting. Even when it's not numbers , you can still use the same principle. May I ask what it is that you want to select?