how to select data from oracle db using loop under listbox

[boss1]

hi all,

i have a problem with loop in select statement.i m using code : [php]
<select name = "s" size = "1" >
<option selected>P-Code</option>
<option value="P01">P01 </option>
<option value="P02">P02 </option>
<option value="P03">P03 </option>
<option value="P04">P04 </option>
</select></td>[/php]
but i want to select all P-CODE from database using loop.

so how can i do this in php. can anybody please help me?

[ronverdonk]

You have been around long enough to know that any code must be enclosed within code tags. And if you still don't know read the Posting Guidelines on the subject.

moderator

[ronverdonk]

Show the select statement you are going to use for populating the select list.

Ronald

[boss1]

hi
thanks for ur response.

the code i have sent u is using manually select item from the list of item and as many item i write inbetween option value that will show from html form.

but i want to retrieve and show all data in the list box for a specific field from database.


thanks.

[ronverdonk]

hi
thanks for ur response.
the code i have sent u is using manually select item from the list of item and as many item i write inbetween option value that will show from html form.

but i want to retrieve and show all data in the list box for a specific field from database.

thanks.

That is exactly why I asked you to show your MySQL select statement. So we can see how to fill the drop down list. Please show it.

Ronald

[ronverdonk]

I did not mean MySQL of course, but since I always do MySQL it is stuck in my keyboard. To show you what I mean here is a piece of code making a form with a select drop down box that is being populated by the database results (note: MySQL). Question: is this what you have in mind?[php] print "<form method='POST' action='".$_SERVER['PHP_SELF']."'}>\n";
print "<select name='selectit'>\n";
while ($info = mysql_fetch_row($result)) {
foreach ($info as $field)
print "<option value='$field'>$field</option>\n";
}
print "</select>\n";
print "<p><input type='submit' value='Submit' id='myButton'/></p>\n";
print "</form>";[/php]Ronald