StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPopulating Multiple Combo Boxes with PHP from MySQL database
primarykey
Id
8223021
data
AcceptedAnswerId
8223176
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-22T06:48:44.367
FavoriteCount
0
LastActivityDate
2011-11-22T07:12:06.720
LastEditDate
LastEditorUserId
0
OwnerUserId
1057095
ParentId
0
PostTypeId
1
Score
0
ViewCount
1786
LastEditorDisplayName
text
Body
<p>I have a maximum of 100 selections (now 79) for the combo box, and have 79 of them. Each one stands for a question and is recorded to "questions" table in MySQL. The options are recorded in a table called "question_codes" and they stand for the field names associated with some questions. I tried 2 for loops within each other but I think that will overload the server because of 79*79 iterations. I also have a text field depending upon the selection with ajax, working properly. Number 0 field in the table "question_codes" is id and I don't use that. Here is my code.</p> <pre><code>$code_query="SELECT * FROM questions WHERE id='1'"; $question_query="SELECT * FROM questions WHERE id='2'"; $result_question_query=mysql_query($question_query,$conn); $result_code_query=mysql_query($code_query,$conn); $selected_query=mysql_query("SELECT * FROM question_codes"); while($row_selected=mysql_fetch_row($selected_query)) { $column_count=count($row_selected); } while($row=mysql_fetch_array($result_question_query) && $row2=mysql_fetch_array($result_code_query)) for($i=1;$i<$column_count;$i++) { $db_q="q$i"; $fill=$row[$db_q]; $fill_code=$row2[$db_q]; print('<tr style="background:navy;color:white"><td width="60px">Question '.$i.'</td> <td> <select name="'.$db_q.'_code" id="'.$db_q.'_code" onchange="showQuestion(this)"> <option value="">Select a question</option> for ($j=1;$j<$column_count;$j++) { $name=mysql_field_name($selected_query,$j); if ($fill_code==$name) { $selected="selected"; } else { $selected=""; } print('<option value="'.$name.'" '.$selected.'>'.$name.'</option>'); } print('</select> </td> <td><input type="text" value="'.$fill.'" name="'.$db_q.'" id="'.$db_q.'"></td></tr>'); </code></pre>
Tags
<php><mysql><loops><populate>
Title
Populating Multiple Combo Boxes with PHP from MySQL database
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. UShuroran
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.