StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18241183
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-08-14T20:01:43.990
FavoriteCount
0
LastActivityDate
2013-08-14T20:12:04.483
LastEditDate
2013-08-14T20:12:04.483
LastEditorUserId
2191572
OwnerUserId
2191572
ParentId
18240993
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<p>For this you will have to get into AJAX, and I highly recommend using jQuery's implementation. You will also need to get a good grip on JSON string coding and decoding.</p> <p>The basic Idea of your code will be like so:</p> <pre><code>// listen for user to change the <select> item $('select#park').on('change', function(){ $.ajax({ url: 'getrides.php' // send a park id to this script ,cache: false // do not cache results in browser ,type: 'POST' // send POST to getrides.php ,data: {'park_id': $('select#park').val()} // getrides.php will receive $_POST['park_id'] ,dataType: 'json' // this AJAX call expects a JSON string as a return value ,success: function(data){ // the data variable will be converted to an array from JSON // check out all your data console.log(data); // loop through your array $.each(data, function(index, info){ // see your array indexes console.log(index); // see data in each array item console.log(info); }); } }); </code></pre> <p><strong>UPDATE</strong></p> <p>You can also load all of the parks and rides into a Javascript array and based on what the user chooses from the dropdown then populate the second dropdown with those array members.</p> <pre><code><script> var rides = new Array(); rides['park1'].push('ride1'); rides['park1'].push('ride2'); rides['park1'].push('ride3'); rides['park1'].push('ride4'); rides['park1'].push('ride5'); rides['park2'].push('ride1'); rides['park2'].push('ride2'); rides['park2'].push('ride3'); rides['park2'].push('ride4'); rides['park2'].push('ride5'); // listen for user to change the <select> item $('select#park').on('change', function(){ // clear current DD options $('select#rides').html(); // loop through array of available rides for selected park $.each(rides[''+$(this).val()+''], function(index, value){ // dynamically create the proper DD options $('select#rides').append('<option>'+value+'</option>'); }); }); </script> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POOne drop down box helps populates the other
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMonkeyZeus
UserOwnerUserId
1. USMonkeyZeus
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. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
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.