how to make select option from a db query

Chrysanthus

hi im trying to make a option selection from a db values that is registerd...

the thing is that i wanna list values in a select option that picks up tha values that are registerd

here is the code i wanna list!

<select NAME="childetopicname" SIZE="1" value="<?php echo $childetopicresult['childetopicname'] ?>"></select>

here is the php code i thing i can use to list select all the values


$childetopic_query = mysql_query("SELECT * FROM childetopics WHERE maintopicID='$maintopicID' ORDER BY childetopicorderstamp") or die (mysql_error());
while ($childetopicresult = mysql_fetch_array($childetopic_query))

ihop some one can help med with this!

swr

Using "value" with select doesn't seem to work. You need to use "selected" on the option itself.

The following code needs some modifications before it will work. Some variable names are wrong (you haven't mentioned the real names), and the code is completely untested, but should help get you rolling:

echo '<select name="childtopicname">';
$childetopic_query = mysql_query("SELECT * FROM childetopics WHERE maintopicID='$maintopicID' ORDER BY childetopicorderstamp") or die (mysql_error());
while ($childetopicresult = mysql_fetch_array($childetopic_query)) {
    // Get value and text from the record
    $optval = $childtopicresult[0];
    $opttext = $childtopicresult[1];

// Check if the thing is selected:
if ($optval == $the_current_value) {
    $selected = 'selected="true"';
}
else {
    $selected = '';
}

// Output the option tag
echo "<option value=\"$optval\" $selected>$opttext</option>";
}
echo '</select>';

Chrysanthus

Okay let me see!! i should really need your help at this i have never don a option selection before some if i give stupid questions then you know why...

sow first part i understand i bit was it supposed to look like this

<select TYPE="TEXT" NAME="maintopicname" SIZE="1" option"<?php echo $maintopic_name['maintopicname']; ?>" WRAP="VIRTUAL"></select>

The second part of the code example is to be in the option field or before the end selection tag??

swr

Not sure I understand your question, but this is what a proper HTML for select element will look like:

<select name="thenameoftheformitem">
<option value="1">First option</option>
<option value="2">Second option</option>
<option value="3" selected="true">Third option</option>
<option value="4">Fourth option</option>
</select>

Does that make more sense now?

The while loop in the code I posted earlier generates the option tags.

Chrysanthus

Nop not tha't i meant!

Thats i wount is to make a selection from a query in my db and after take the value from the query and put it in the selecion field sow that you can select the value that you seek or in my case i wount to select a forum topic that i made and the select where to move the selected topic and it's post to anoter main topic...

Like this

--selelct topic to move--

|Liste the valuers of all the topics in this main topic|

--selelct childe topic to move to--

|Liste the valuers of all the maintopics to put the childe topic there|

Now do you get it??