StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to empty select box when "Please Select" option is chosen
primarykey
Id
14249704
data
AcceptedAnswerId
14251755
AnswerCount
3
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2013-01-10T02:00:14.630
FavoriteCount
0
LastActivityDate
2013-01-10T06:04:53.250
LastEditDate
2013-01-10T02:07:54.207
LastEditorUserId
1936125
OwnerUserId
1964964
ParentId
0
PostTypeId
1
Score
0
ViewCount
3425
LastEditorDisplayName
text
Body
<p>I have a drop down menu and an empty select box below:</p> <pre><code><select name="session" id="sessionsDrop"> <option value="">Please Select</option> <option value='20'>EWYGC - 10-01-2013 - 09:00</option> <option value='22'>WDFRK - 11-01-2013 - 10:05</option> </select> </p> $studentSELECT = ""; $studentSELECT .= '<select name="studenttextarea" id="studentselect" size="6">'; $studentSELECT .= '</select>'; </code></pre> <p>The above is in the <code>addstudent.php</code> page:</p> <p>Now what happens is that I have a php code where depending on which assessment is chosen from drop down menu, it runs a query and it displays either a list of students in the select box if rows from the db are found, if no rows are found then it simply displays a message stating that no students were found within an assessment in the select box. The code for this is below which is in the <code>addedstudents.php</code> page and is accessed through ajax.</p> <pre><code>$studentnum = $currentstudentstmt->num_rows(); $studentSELECT = ""; if($studentnum == 0){ $studentSELECT .= "<option disabled='disabled' class='red' value=''>No Students currently in this Assessment</option>"; } else { while ( $currentstudentstmt->fetch() ) { $studentSELECT .= sprintf("<option disabled='disabled' value='%s'>%s - %s %s</option>", $dbStudentId, $dbStudentAlias, $dbStudentForename, $dbStudentSurname) . PHP_EOL; } } echo $studentSELECT; </code></pre> <p>The problem I have is that if the user selects the <code>Please Select</code> option, it still displays the message stating no assessments are found, this is because obviously there are no modules in this query so it thinks that as it has no rows display the message. But I don't want this to be dislayed if the <code>Please Select</code> option is selected, I just want the select box to just be empty. </p> <p>Problem is that even though I tried to use jquery to do this, what happens is the select box goes empty but then comes back with the message milliseconds later.</p> <p>My question is that if the <code>Please Select</code> option is chosen from drop down menu, what is best way to be able to display an empty select box?</p> <p>Below is attempt of this through jquery:</p> <pre><code>$('#sessionsDrop').change( function(){ if( $(this).val() == '' ){ $('#studentselect').val(''); } }); </code></pre>
Tags
<php><jquery>
Title
How to empty select box when "Please Select" option is chosen
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USAngel
UserOwnerUserId
1. USuser1964964
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
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POHow to empty select box when "Please Select" option is chosen
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
CommentsPostId

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.