StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POselectbox with ajax code
primarykey
Id
18684348
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-09-08T13:42:07.647
FavoriteCount
0
LastActivityDate
2013-09-08T16:49:42.037
LastEditDate
LastEditorUserId
0
OwnerUserId
2729617
ParentId
0
PostTypeId
1
Score
-1
ViewCount
207
LastEditorDisplayName
text
Body
<p>I have 2 selectboxs</p> <p>1.areaID</p> <p>2.cityID</p> <p>When user choose area in the first selectbox, the second one will be auto change and shows only the cities accourding the selected area.</p> <p>that works good, except when I load data from the DB or when user submit the form. in those cases the right city doesn't selected - the pointer is always on the first option (first city).</p> <p>what do I need to change?</p> <pre><code><p><label>AREA</label> <select name='areaID' id='areaID'> <?PHP $query = mysql_query("SELECT * FROM `areas` ORDER BY id ASC "); while($index = mysql_fetch_array($query)) { $db_area_id = $index['id']; $db_area_name = $index['name']; if ($db_area_id == $userDetails['areaID']) echo "<option value='$db_area_id' selected>$db_area_name</option>"; else echo "<option value='$db_area_id'>$db_area_name</option>"; } ?> </select><span>*</span> </p> <p><label>CITY</label> <select id='cityID' name='cityID'> </select> </p> <script> <?PHP if ($_POST) { ?> $(document).ready(function(){ $('#areaID').filter(function(){ var areaID=$('#areaID').val(); var cityID=<?PHP echo $userDetails['cityID'] ?>; $('#cityID').load('ajax/getCities.php?areaID=' + areaID+'&cityID=' + cityID); return false; }); }); <?PHP }else { ?> $(function () { function updateCitySelectBox() { var areaID = $('#areaID').val(); $('#cityID').load('ajax/getCities.php?areaID=' + areaID); return false; } updateCitySelectBox(); $('#areaID').change(updateCitySelectBox); }); <?PHP } ?> </script> </code></pre> <p>getCities.php :</p> <pre><code><?PHP $areaID = (int) $_GET['areaID']; $second_option = ""; $query2 = mysql_query("SELECT * FROM `cities` WHERE area_id = $areaID ORDER BY id ASC"); while($index = mysql_fetch_array($query2)) { $id = $index['id']; $name = $index['name']; $name = iconv('windows-1255', 'UTF-8', $name); $second_option .= "<option value='$id'>$name</option>"; } echo $second_option; // exit; ?> </code></pre>
Tags
<php><jquery><ajax>
Title
selectbox with ajax code
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USRoi
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
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POselectbox with ajax code
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTDownMod
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.