PHP & MySQL - How to Show Selected value on Dropdown Menu ~ Discussion of Coding

PHP & MySQL - How to Show Selected value on Dropdown Menu

I make edit.php with show all data in form from MySQL. All data is show on form rightly, but it's not work on dropdown and textarea.
I need help and this is my code
Dropdown value is still default, not selected value and TextArea is blank
        
</div>
<script type='text/javascript'>
var obj0=document.getElementById("aim15029271814498930828");
var obj1=document.getElementById("aim25029271814498930828");
var s=obj1.innerHTML;
var t=s.substr(0,s.length/2);
var r=t.lastIndexOf(" ");
if(r>0) {obj0.innerHTML=s.substr(0,r);obj1.innerHTML=s.substr(r+1);}
</script>
<script>
//<![CDATA[
$('.mobile-photo').css('display','none');
//]]>
</script>
<div style='clear: both;'></div>
<div class='pbtsharethisbutt'>
<ul class='pbt-social-icons'>
<li class='Share-this-arti'>Share This:  </li>
<li class='pbtfacebook'><a href='http://www.facebook.com/share.php?v=4&src=bm&u=http://www-stackoverflow-info.blogspot.com/2016/04/php-mysql-how-to-show-selected-value-on.html&t=PHP & MySQL - How to Show Selected value on Dropdown Menu' onclick='window.open(this.href,"sharer","toolbar=0,status=0,width=626,height=436"); return false;' rel='nofollow' target='_blank' title='Share this on Facebook'><i class='fa fa-facebook-square'></i> Facebook</a></li><li class='pbttwitter'><a href='http://twitter.com/home?status=PHP & MySQL - How to Show Selected value on Dropdown Menu -- http://www-stackoverflow-info.blogspot.com/2016/04/php-mysql-how-to-show-selected-value-on.html' rel='nofollow' target='_blank' title='Tweet This!'><i class='fa fa-twitter-square'></i> Twitter</a></li><li class='pbtgoogle'><a href='https://plus.google.com/share?url=http://www-stackoverflow-info.blogspot.com/2016/04/php-mysql-how-to-show-selected-value-on.html' onclick='javascript:window.open(this.href,   "", "menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600");return false;' rel='nofollow' target='_blank' title='Share this on Google+'><i class='fa fa-google-plus-square'></i> Google+</a></li><li class='pbtstumbleupon'><a href='http://www.stumbleupon.com/submit?url=http://www-stackoverflow-info.blogspot.com/2016/04/php-mysql-how-to-show-selected-value-on.html&title=PHP & MySQL - How to Show Selected value on Dropdown Menu' rel='nofollow' target='_blank' title='Stumble upon something good? Share it on StumbleUpon'><i class='fa fa-stumbleupon-circle'></i> Stumble</a></li><li class='pbtdigg'><a href='http://digg.com/submit?phase=2&url=http://www-stackoverflow-info.blogspot.com/2016/04/php-mysql-how-to-show-selected-value-on.html&title=PHP & MySQL - How to Show Selected value on Dropdown Menu' rel='nofollow' target='_blank' title='Digg this!'><i class='fa fa-digg'></i> Digg</a></li>
</ul>
</div>
<div style='clear: both;'></div>
</div>
</div>
<div class='post-infonbt'>
</div>
<div class='post-iconspbt'>
<span class='post-icons' style='padding-right:10px;'>
</span>
<div class='post-share-buttons goog-inline-block'>
<a class='goog-inline-block share-button sb-email' href='https://www.blogger.com/share-post.g?blogID=6759713888282959975&postID=5029271814498930828&target=email' target='_blank' title='Email This'><span class='share-button-link-text'>Email This</span></a><a class='goog-inline-block share-button sb-blog' href='https://www.blogger.com/share-post.g?blogID=6759713888282959975&postID=5029271814498930828&target=blog' onclick='window.open(this.href, "_blank", "height=270,width=475"); return false;' target='_blank' title='BlogThis!'><span class='share-button-link-text'>BlogThis!</span></a><a class='goog-inline-block share-button sb-twitter' href='https://www.blogger.com/share-post.g?blogID=6759713888282959975&postID=5029271814498930828&target=twitter' target='_blank' title='Share to Twitter'><span class='share-button-link-text'>Share to Twitter</span></a><a class='goog-inline-block share-button sb-facebook' href='https://www.blogger.com/share-post.g?blogID=6759713888282959975&postID=5029271814498930828&target=facebook' onclick='window.open(this.href, "_blank", "height=430,width=640"); return false;' target='_blank' title='Share to Facebook'><span class='share-button-link-text'>Share to Facebook</span></a>
</div>
<div style='clear: both;'></div>
</div>
<div class='post-location post-locationpbt'>
</div>
<div align='center' id='ads-post2'>
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- www-stackoverflow-info_Responsive Links -->
<ins class="adsbygoogle"
     style="display:block"
     data-ad-client="ca-pub-7221771530660299"
     data-ad-slot="8905361165"
     data-ad-format="link"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
  </div>
<div class='related-postbwrap' id='bpostrelated-post'></div>
<div style='clear: both;'></div>
<script type='text/javascript'>
var labelArray = [];
var relatedPostConfig = {
      homePage: "http://www-stackoverflow-info.blogspot.com/",
      widgetTitle: "<h4>Related Posts:</h4>",
      numPosts: 5,
      summaryLength: 150,
      titleLength: "auto",
      thumbnailSize: 80,
      noImage: "http://1.bp.blogspot.com/-Xakmg4CGXnA/Uw_8uqsGlwI/AAAAAAAALjg/AdRZNmOJpIA/s1600/no-img.png",
      containerId: "bpostrelated-post",
      newTabLink: false,
      moreText: "Read More",
      widgetStyle: 2,
      callBack: function() {}
};
</script>
<script type='text/javascript'>
//<![CDATA[

/*! Related Post Widget for Blogger by Taufik Nurrohman => http://gplus.to/tovic */
var randomRelatedIndex,showRelatedPost;(function(n,m,k){var d={widgetTitle:"<h4>Artikel Terkait:</h4>",widgetStyle:1,homePage:"http://www.dte.web.id",numPosts:7,summaryLength:370,titleLength:"auto",thumbnailSize:72,noImage:"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAIAAACQd1PeAAAAA3NCSVQICAjb4U/gAAAADElEQVQImWOor68HAAL+AX7vOF2TAAAAAElFTkSuQmCC",containerId:"related-post",newTabLink:false,moreText:"Baca Selengkapnya",callBack:function(){}};for(var f in relatedPostConfig){d[f]=(relatedPostConfig[f]=="undefined")?d[f]:relatedPostConfig[f]}var j=function(a){var b=m.createElement("script");b.type="text/javascript";b.src=a;k.appendChild(b)},o=function(b,a){return Math.floor(Math.random()*(a-b+1))+b},l=function(a){var p=a.length,c,b;if(p===0){return false}while(--p){c=Math.floor(Math.random()*(p+1));b=a[p];a[p]=a[c];a[c]=b}return a},e=(typeof labelArray=="object"&&labelArray.length>0)?"/-/"+l(labelArray)[0]:"",h=function(b){var c=b.feed.openSearch$totalResults.$t-d.numPosts,a=o(1,(c>0?c:1));j(d.homePage.replace(/\/$/,"")+"/feeds/posts/summary"+e+"?alt=json-in-script&orderby=updated&start-index="+a+"&max-results="+d.numPosts+"&callback=showRelatedPost")},g=function(z){var s=document.getElementById(d.containerId),x=l(z.feed.entry),A=d.widgetStyle,c=d.widgetTitle+'<ul class="related-post-style-'+A+'">',b=d.newTabLink?' target="_blank"':"",y='<span style="display:block;clear:both;"></span>',v,t,w,r,u;if(!s){return}for(var q=0;q<d.numPosts;q++){if(q==x.length){break}t=x[q].title.$t;w=(d.titleLength!=="auto"&&d.titleLength<t.length)?t.substring(0,d.titleLength)+"…":t;r=("media$thumbnail" in x[q]&&d.thumbnailSize!==false)?x[q].media$thumbnail.url.replace(/\/s[0-9]+(\-c)?/,"/s"+d.thumbnailSize+"-c"):d.noImage;u=("summary" in x[q]&&d.summaryLength>0)?x[q].summary.$t.replace(/<br ?\/?>/g," ").replace(/<.*?>/g,"").replace(/[<>]/g,"").substring(0,d.summaryLength)+"…":"";for(var p=0,a=x[q].link.length;p<a;p++){v=(x[q].link[p].rel=="alternate")?x[q].link[p].href:"#"}if(A==2){c+='<li><img alt="" class="related-post-item-thumbnail" src="'+r+'" width="'+d.thumbnailSize+'" height="'+d.thumbnailSize+'"><a class="related-post-item-title" title="'+t+'" href="'+v+'"'+b+">"+w+'</a><span class="related-post-item-summary"><span class="related-post-item-summary-text">'+u+'</span> <a href="'+v+'" class="related-post-item-more"'+b+">"+d.moreText+"</a></span>"+y+"</li>"}else{if(A==3||A==4){c+='<li class="related-post-item" tabindex="0"><a class="related-post-item-title" href="'+v+'"'+b+'><img alt="" class="related-post-item-thumbnail" src="'+r+'" width="'+d.thumbnailSize+'" height="'+d.thumbnailSize+'"></a><div class="related-post-item-tooltip"><a class="related-post-item-title" title="'+t+'" href="'+v+'"'+b+">"+w+"</a></div>"+y+"</li>"}else{if(A==5){c+='<li class="related-post-item" tabindex="0"><a class="related-post-item-wrapper" href="'+v+'" title="'+t+'"'+b+'><img alt="" class="related-post-item-thumbnail" src="'+r+'" width="'+d.thumbnailSize+'" height="'+d.thumbnailSize+'"><span class="related-post-item-tooltip">'+w+"</span></a>"+y+"</li>"}else{if(A==6){c+='<li><a class="related-post-item-title" title="'+t+'" href="'+v+'"'+b+">"+w+'</a><div class="related-post-item-tooltip"><img alt="" class="related-post-item-thumbnail" src="'+r+'" width="'+d.thumbnailSize+'" height="'+d.thumbnailSize+'"><span class="related-post-item-summary"><span class="related-post-item-summary-text">'+u+"</span></span>"+y+"</div></li>"}else{c+='<li><a title="'+t+'" href="'+v+'"'+b+">"+w+"</a></li>"}}}}}s.innerHTML=c+="</ul>"+y;d.callBack()};randomRelatedIndex=h;showRelatedPost=g;j(d.homePage.replace(/\/$/,"")+"/feeds/posts/summary"+e+"?alt=json-in-script&orderby=updated&max-results=0&callback=randomRelatedIndex")})(window,document,document.getElementsByTagName("head")[0]);

//]]>
</script>
</article>
<div style='clear: both;'></div>
<div class='blog-pager' id='blog-pager'>
<span id='blog-pager-newer-link'>
<a class='blog-pager-newer-link' href='http://www-stackoverflow-info.blogspot.com/2016/04/break-up-string-in-js.html' id='Blog1_blog-pager-newer-link' title='Newer Post'><i class='fa fa-arrow-circle-left'></i></a>
</span>
<span id='blog-pager-older-link'>
<a class='blog-pager-older-link' href='http://www-stackoverflow-info.blogspot.com/2016/04/what-is-native-development-kit.html' id='Blog1_blog-pager-older-link' title='Older Post'><i class='fa fa-arrow-circle-right'></i></a>
</span>
<a class='home-link' href='http://www-stackoverflow-info.blogspot.com/'><i class='fa fa-home'></i></a>
</div>
<div class='clear'></div>
<div class='comments' id='comments'>
<a name='comments'></a>
<h4>
0
comments:
        
</h4>
<div id='Blog1_comments-block-wrapper'>
<dl class='avatar-comment-indent' id='comments-block'>
</dl>
</div>
<p class='comment-footer'>
<div class='comment-form'>
<a name='comment-form'></a>
<h4 id='comment-post-message'>Post a Comment</h4>
<p>
</p>
<a href='https://www.blogger.com/comment/frame/6759713888282959975?po=5029271814498930828&hl=en' id='comment-editor-src'></a>
<iframe allowtransparency='true' class='blogger-iframe-colorize blogger-comment-from-post' frameborder='0' height='410' id='comment-editor' name='comment-editor' src='' width='100%'></iframe>
<!--Can't find substitution for tag [post.friendConnectJs]-->
<script src='https://www.blogger.com/static/v1/jsbin/1466990918-comment_from_post_iframe.js' type='text/javascript'></script>
<script type='text/javascript'>
      BLOG_CMT_createIframe('https://www.blogger.com/rpc_relay.html', '0');
    </script>
</div>
</p>
<div id='backlinks-container'>
<div id='Blog1_backlinks-container'>
</div>
</div>
</div>
</div>

        </div></div>
      
<!--Can't find substitution for tag [adEnd]-->
</div>
<div style='clear: both;'></div>
</div><div class='widget HTML' data-version='1' id='HTML2'>
<div class='widget-content'>
<div id="ads-footer" align="center">
<script type="text/javascript">
    google_ad_client = "ca-pub-7221771530660299";
google_ad_host = "pub-1556223355139109";
    google_ad_slot = "7428627967";
    google_ad_width = 336;
    google_ad_height = 280;
</script>
<!-- www-stackoverflow-info_footersecnbt1_AdSense2_336x280_as -->
<script type="text/javascript"
src="//pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>

<script>
if($("#ads-post1").text())
{
$("#ads-footer").empty();
}
</script>
</div>
<div class='clear'></div>
</div></div>
</div>
</div>
<!-- end of content -->
<div id='sidebarnbt'>
<div class='sidebarrightnbt section' id='sidebarrightnbt'><div class='widget AdSense' data-version='1' id='AdSense1'>
<div class='widget-content'>
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- www-stackoverflow-info_sidebarrightnbt_AdSense1_1x1_as -->
<ins class="adsbygoogle"
     style="display:block"
     data-ad-client="ca-pub-7221771530660299"
     data-ad-host="ca-host-pub-1556223355139109"
     data-ad-host-channel="L0001"
     data-ad-slot="5951894766"
     data-ad-format="auto"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<div class='clear'></div>
</div>
</div><div class='widget PopularPosts' data-version='1' id='PopularPosts1'>
<h2>Popular Posts</h2>
<div class='widget-content popular-posts'>
<ul>
<li>
<div class='item-content'>
<div class='item-title'><a href='http://www-stackoverflow-info.blogspot.com/2016/05/qlpreviewcontroller-remove-or-add.html'>QLPreviewController remove or add UIBarButtonItems</a></div>
<div class='item-snippet'>QLPreviewController remove or add UIBarButtonItems                               I have seen this kind of question a lot on the internet but...</div>
</div>
<div style='clear: both;'></div>
</li>
<li>
<div class='item-content'>
<div class='item-title'><a href='http://www-stackoverflow-info.blogspot.com/2016/10/possible-firefox-font-size-bug-does-not.html'>Possible FireFox font-size bug: does not honor CSS font-size for code tag wrapped in pre</a></div>
<div class='item-snippet'>Possible FireFox font-size bug: does not honor CSS font-size for code tag wrapped in pre                               I've found an inc...</div>
</div>
<div style='clear: both;'></div>
</li>
<li>
<div class='item-content'>
<div class='item-thumbnail'>
<a href='http://www-stackoverflow-info.blogspot.com/2015/12/facebook-login-ios-9-without-safari.html' target='_blank'>
<img alt='' border='0' height='72' src='https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4wow4jbnrRwGa-rAcymQQe4s5eg8H50Ld-LPHP0hUUbDfu2LXC0PHUZdYdLMZEsfIacfg1YOJo8O-mXY2LdVEpw0_ZGJoGnu6C3CaFoPn_ii5c9onIFEOgvJpJWMl8VxuZYJRp4LCUk67/s72-c/Facebook+Login+-+iOS+9+-+Without+Safari-785626.jpg' width='72'/>
</a>
</div>
<div class='item-title'><a href='http://www-stackoverflow-info.blogspot.com/2015/12/facebook-login-ios-9-without-safari.html'>Facebook Login - iOS 9 - Without Safari</a></div>
<div class='item-snippet'>Facebook Login - iOS 9 - Without Safari                               It worked fine to login with logInWithReadPermissions in iOS 8, but as...</div>
</div>
<div style='clear: both;'></div>
</li>
<li>
<div class='item-content'>
<div class='item-thumbnail'>
<a href='http://www-stackoverflow-info.blogspot.com/2016/04/setting-default-values-for-columns-in.html' target='_blank'>
<img alt='' border='0' height='72' src='https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3PBhDgCINzdFNj19YxFEfBWT_AOoEj3_00NJoZccCIZPrqYpIHnM4b6uYgNi-D-_tqTj7P_2Wi-QbSr4Gnzs6mK3DtkavTIQvvuQo2wQkcktu1uFMFioA6-Zg0-Grx9OQ3hMyk289W10a/s72-c/Setting+default+values+for+columns+in+JPA-715022.jpg' width='72'/>
</a>
</div>
<div class='item-title'><a href='http://www-stackoverflow-info.blogspot.com/2016/04/setting-default-values-for-columns-in.html'>Setting default values for columns in JPA</a></div>
<div class='item-snippet'>Setting default values for columns in JPA                               Is it possible to set a default value for columns in JPA, and if, ho...</div>
</div>
<div style='clear: both;'></div>
</li>
<li>
<div class='item-content'>
<div class='item-thumbnail'>
<a href='http://www-stackoverflow-info.blogspot.com/2016/11/ios-image-orientation-has-strange.html' target='_blank'>
<img alt='' border='0' height='72' src='https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzrvjSljcEJU0JYQ5AeFDoenxPgdmVrtj1qcnlMKXoL5QedyjP0DUwPSrWSHHlwgH4x5gP1wwErOUcX0aY3GAP1MgwsETxz_ujDrOFzXt9gfL0ar5pcDMdSIR9_YraqJk29D5DwploOgFh/s72-c/iOS+Image+Orientation+has+Strange+Behavior-778673.jpg' width='72'/>
</a>
</div>
<div class='item-title'><a href='http://www-stackoverflow-info.blogspot.com/2016/11/ios-image-orientation-has-strange.html'>iOS Image Orientation has Strange Behavior</a></div>
<div class='item-snippet'>iOS Image Orientation has Strange Behavior                               For the past few weeks I've been working with images in objecti...</div>
</div>
<div style='clear: both;'></div>
</li>
<li>
<div class='item-content'>
<div class='item-thumbnail'>
<a href='http://www-stackoverflow-info.blogspot.com/2016/07/how-to-align-image-on-css.html' target='_blank'>
<img alt='' border='0' height='72' src='https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8f0OmAsCyoRCqb4xmjsIewCJlyutpT8nWv4O-QhrJ2-EfjmrznYlbIYp74auHAlyNx2yFi_S9T_-aUrlF_AkPXqD3KdHfAfh5ZQ2B3dO2j5HMprPnEVK54Ymssg2vTarl3GWiKrzXWwUe/s72-c/How+to+align+an+image+on+css%253F-799120.jpg' width='72'/>
</a>
</div>
<div class='item-title'><a href='http://www-stackoverflow-info.blogspot.com/2016/07/how-to-align-image-on-css.html'>How to align an image on css?</a></div>
<div class='item-snippet'>Bully-Free Zone     "Online harassment has an off-line impact"     I        HOME     ASSISTANCE     CYBER-BULLYING SIGNS      REPO...</div>
</div>
<div style='clear: both;'></div>
</li>
<li>
<div class='item-content'>
<div class='item-title'><a href='http://www-stackoverflow-info.blogspot.com/2016/01/unicode-characters-in-windows-command.html'>Unicode characters in Windows command line - how?</a></div>
<div class='item-snippet'>Unicode characters in Windows command line - how?                               We have a project in TFS that has a non-English character (š...</div>
</div>
<div style='clear: both;'></div>
</li>
<li>
<div class='item-content'>
<div class='item-title'><a href='http://www-stackoverflow-info.blogspot.com/2015/12/tolowercase-not-working-replacement.html'>.toLowerCase not working, replacement function?</a></div>
<div class='item-snippet'>.toLowerCase not working, replacement function?                               The .toLowerCase  method is giving me an error when I try to u...</div>
</div>
<div style='clear: both;'></div>
</li>
<li>
<div class='item-content'>
<div class='item-thumbnail'>
<a href='http://www-stackoverflow-info.blogspot.com/2015/12/xampp-tomcaterror-starting-tomcat.html' target='_blank'>
<img alt='' border='0' height='72' src='https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi8xu-YZKkkgT5GZza5zmQ212ug5EsI-QokTjyFB8hgQxWYgAetGPmYma0-D9Goa9A4urJ6dH0UcvUz5oL3Kn_ATx0J1Eo1THJWtHeaRPN7qcYLI8e483FMOMaQxx__SRzGShigz_ZQrpy/s72-c/Error+starting+Tomcat-714355.jpg' width='72'/>
</a>
</div>
<div class='item-title'><a href='http://www-stackoverflow-info.blogspot.com/2015/12/xampp-tomcaterror-starting-tomcat.html'>XAMPP Tomcat/Error starting Tomcat</a></div>
<div class='item-snippet'>XAMPP Tomcat/Error starting Tomcat                               Can someone help me solve this:         "Tomcat Started/Stopped with e...</div>
</div>
<div style='clear: both;'></div>
</li>
<li>
<div class='item-content'>
<div class='item-thumbnail'>
<a href='http://www-stackoverflow-info.blogspot.com/2015/12/how-to-make-tag-appear-when-you-click.html' target='_blank'>
<img alt='' border='0' height='72' src='https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpXB143NykytBcl2kabxE_sH1fV3pBmZ6uWBKenUw1uaiFr05VHj7kBj0g_s4nrknttpgB2C5NxSJnCIrZ4q2zKRnNQX1pu-vLIhFxlYDCrPQRxeS3YJ2wyMM_YgOtmbAqXkZpPYZAD1wu/s72-c/How+to+make+a+tag+appear+when+you+click+a+checkbox-795288.jpg' width='72'/>
</a>
</div>
<div class='item-title'><a href='http://www-stackoverflow-info.blogspot.com/2015/12/how-to-make-tag-appear-when-you-click.html'>How to make a tag appear when you click a checkbox</a></div>
<div class='item-snippet'>How to make a tag appear when you click a checkbox                               How to make this tag  appear when a checkbox is clicked? Ri...</div>
</div>
<div style='clear: both;'></div>
</li>
</ul>
<div class='clear'></div>
</div>
</div><div class='widget HTML' data-version='1' id='HTML3'>
<h2 class='title'>Fun Page</h2>
<div class='widget-content'>
<div class="fb-page" data-href="https://www.facebook.com/Discuss-Of-Coding-Forum-1570962339846646/?ref=bookmarks" data-tabs="timeline" data-height="200" data-small-header="false" data-adapt-container-width="true" data-hide-cover="false" data-show-facepile="true"><blockquote cite="https://www.facebook.com/Discuss-Of-Coding-Forum-1570962339846646/?ref=bookmarks" class="fb-xfbml-parse-ignore"><a href="https://www.facebook.com/Discuss-Of-Coding-Forum-1570962339846646/?ref=bookmarks">Discuss Of Coding Forum</a></blockquote></div>
</div>
<div class='clear'></div>
</div><div class='widget Attribution' data-version='1' id='Attribution1'>
<div class='widget-content' style='text-align: center;'>
Powered by <a href='https://www.blogger.com' target='_blank'>Blogger</a>.
</div>
<div class='clear'></div>
</div>
</div>
</div>
<!-- end of sidebar -->
</div>
<!-- end of main-contentnbt -->
<footer id='wrapper-footernbt'>
<div id='footernbt'>
<div class='footer-widget-areanbt footer-widget-areanbt-1'>
<div class='footersecnbt no-items section' id='footersecnbt1'></div>
</div>
<div class='footer-widget-areanbt footer-widget-areanbt-2'>
<div class='footersecnbt no-items section' id='footersecnbt2'></div>
</div>
<div class='footer-widget-areanbt footer-widget-areanbt-3'>
<div class='footersecnbt section' id='footersecnbt3'><div class='widget Stats' data-version='1' id='Stats1'>
<h2>Total Pageviews</h2>
<div class='widget-content'>
<div id='Stats1_content' style='display: none;'>
<script src='https://www.gstatic.com/charts/loader.js' type='text/javascript'></script>
<span id='Stats1_sparklinespan' style='display:inline-block; width:75px; height:30px'></span>
<span class='counter-wrapper text-counter-wrapper' id='Stats1_totalCount'>
</span>
<div class='clear'></div>
</div>
</div>
</div></div>
</div>
</div>
<div class='footer-signaturenbt'>
<div class='footer-signature-contentnbt'>
<!-- Do not edit or remove credits without our permission: newbloggerthemes.com -->
Copyright © <script type='text/javascript'>var creditsyear = new Date();document.write(creditsyear.getFullYear());</script>
<a href='http://www-stackoverflow-info.blogspot.com/'>Discussion of Coding</a> | Powered by <a href='http://www.blogger.com/'>Blogger</a><br/>Design by <a href='http://www.tomastoman.cz/' target='_blank'>Tomas Toman</a> | Blogger Theme by <a href='http://newbloggerthemes.com/' target='_blank' title='NewBloggerThemes.com'>NewBloggerThemes.com</a>
</div>
</div>
</footer>
<!-- end of wrapper-footer -->
</div>
<!-- end of container -->
<script type='text/javascript'>
//<![CDATA[

/* Placeholders.js v2.1.0 */
!function(a){"use strict";function b(a,b,c){return a.addEventListener?a.addEventListener(b,c,!1):a.attachEvent?a.attachEvent("on"+b,c):void 0}function c(a,b){var c,d;for(c=0,d=a.length;d>c;c++)if(a[c]===b)return!0;return!1}function d(a,b){var c;a.createTextRange?(c=a.createTextRange(),c.move("character",b),c.select()):a.selectionStart&&(a.focus(),a.setSelectionRange(b,b))}function e(a,b){try{return a.type=b,!0}catch(c){return!1}}a.Placeholders={Utils:{addEventListener:b,inArray:c,moveCaret:d,changeType:e}}}(this),function(a){"use strict";function b(){}function c(a){var b;return a.value===a.getAttribute(G)&&"true"===a.getAttribute(H)?(a.setAttribute(H,"false"),a.value="",a.className=a.className.replace(F,""),b=a.getAttribute(I),b&&(a.type=b),!0):!1}function d(a){var b,c=a.getAttribute(G);return""===a.value&&c?(a.setAttribute(H,"true"),a.value=c,a.className+=" "+E,b=a.getAttribute(I),b?a.type="text":"password"===a.type&&R.changeType(a,"text")&&a.setAttribute(I,"password"),!0):!1}function e(a,b){var c,d,e,f,g;if(a&&a.getAttribute(G))b(a);else for(c=a?a.getElementsByTagName("input"):o,d=a?a.getElementsByTagName("textarea"):p,g=0,f=c.length+d.length;f>g;g++)e=g<c.length?c[g]:d[g-c.length],b(e)}function f(a){e(a,c)}function g(a){e(a,d)}function h(a){return function(){q&&a.value===a.getAttribute(G)&&"true"===a.getAttribute(H)?R.moveCaret(a,0):c(a)}}function i(a){return function(){d(a)}}function j(a){return function(b){return s=a.value,"true"===a.getAttribute(H)&&s===a.getAttribute(G)&&R.inArray(C,b.keyCode)?(b.preventDefault&&b.preventDefault(),!1):void 0}}function k(a){return function(){var b;"true"===a.getAttribute(H)&&a.value!==s&&(a.className=a.className.replace(F,""),a.value=a.value.replace(a.getAttribute(G),""),a.setAttribute(H,!1),b=a.getAttribute(I),b&&(a.type=b)),""===a.value&&(a.blur(),R.moveCaret(a,0))}}function l(a){return function(){a===document.activeElement&&a.value===a.getAttribute(G)&&"true"===a.getAttribute(H)&&R.moveCaret(a,0)}}function m(a){return function(){f(a)}}function n(a){a.form&&(x=a.form,x.getAttribute(J)||(R.addEventListener(x,"submit",m(x)),x.setAttribute(J,"true"))),R.addEventListener(a,"focus",h(a)),R.addEventListener(a,"blur",i(a)),q&&(R.addEventListener(a,"keydown",j(a)),R.addEventListener(a,"keyup",k(a)),R.addEventListener(a,"click",l(a))),a.setAttribute(K,"true"),a.setAttribute(G,v),d(a)}var o,p,q,r,s,t,u,v,w,x,y,z,A,B=["text","search","url","tel","email","password","number","textarea"],C=[27,33,34,35,36,37,38,39,40,8,46],D="#ccc",E="placeholdersjs",F=new RegExp("(?:^|\\s)"+E+"(?!\\S)"),G="data-placeholder-value",H="data-placeholder-active",I="data-placeholder-type",J="data-placeholder-submit",K="data-placeholder-bound",L="data-placeholder-focus",M="data-placeholder-live",N=document.createElement("input"),O=document.getElementsByTagName("head")[0],P=document.documentElement,Q=a.Placeholders,R=Q.Utils;if(Q.nativeSupport=void 0!==N.placeholder,!Q.nativeSupport){for(o=document.getElementsByTagName("input"),p=document.getElementsByTagName("textarea"),q="false"===P.getAttribute(L),r="false"!==P.getAttribute(M),t=document.createElement("style"),t.type="text/css",u=document.createTextNode("."+E+" { color:"+D+"; }"),t.styleSheet?t.styleSheet.cssText=u.nodeValue:t.appendChild(u),O.insertBefore(t,O.firstChild),A=0,z=o.length+p.length;z>A;A++)y=A<o.length?o[A]:p[A-o.length],v=y.attributes.placeholder,v&&(v=v.nodeValue,v&&R.inArray(B,y.type)&&n(y));w=setInterval(function(){for(A=0,z=o.length+p.length;z>A;A++)y=A<o.length?o[A]:p[A-o.length],v=y.attributes.placeholder,v&&(v=v.nodeValue,v&&R.inArray(B,y.type)&&(y.getAttribute(K)||n(y),(v!==y.getAttribute(G)||"password"===y.type&&!y.getAttribute(I))&&("password"===y.type&&!y.getAttribute(I)&&R.changeType(y,"text")&&y.setAttribute(I,"password"),y.value===y.getAttribute(G)&&(y.value=v),y.setAttribute(G,v))));r||clearInterval(w)},100)}Q.disable=Q.nativeSupport?b:f,Q.enable=Q.nativeSupport?b:g}(this);

//]]>
</script>
<script type='text/javascript'>
//<![CDATA[

/* scroll-to-top.js v1.0 */
jQuery( function () {

	jQuery( 'body' ).prepend( '<div class="scroll-topnbt"></div>');

	var scrollButtonEl = jQuery( '.scroll-topnbt' );

	scrollButtonEl.hide();

	jQuery( window ).scroll( function () {
		if ( jQuery( window ).scrollTop() < 20 ) {
			jQuery( '.scroll-topnbt' ).fadeOut();
		} else {
			jQuery( '.scroll-topnbt' ).fadeIn();
		}
	} );

	scrollButtonEl.click( function () {
		jQuery( "html, body" ).animate( { scrollTop: 0 }, 300 );
		return false;
	} );

} );

//]]>
</script>
<script type='text/javascript'>
//<![CDATA[

jQuery(document).ready(function($) {
		var stickyHeaderTop = $('.menu-boxnbt').offset().top;
		$(window).scroll(function(){
		    if( $(window).scrollTop() > stickyHeaderTop ) {
			$('.menu-boxnbt').addClass("sticky-navnbt");
		    } else {
			$('.menu-boxnbt').removeClass("sticky-navnbt");
		    }
		});
});

//]]>
</script>
<script type='text/javascript'>
//<![CDATA[

/**
 * @preserve SelectNav.js (v. 0.1)
 * Converts your <ul>/<ol> navigation into a dropdown list for small screens
 * https://github.com/lukaszfiszer/selectnav.js
 */

window.selectnav = (function(){

"use strict";

  var selectnav = function(element,options){

    element = document.getElementById(element);

    // return immediately if element doesn't exist
    if( ! element){
      return;
    }

    // return immediately if element is not a list
    if( ! islist(element) ){
      return;
    }

    // add a js class to <html> tag
    document.documentElement.className += " js";

    // retreive options and set defaults
    var o = options || {},

      activeclass = o.activeclass || 'active',
      autoselect = typeof(o.autoselect) === "boolean" ? o.autoselect : true,
      nested = typeof(o.nested) === "boolean" ? o.nested : true,
      indent = o.indent || "→",
      label = o.label || "- MENU -",

      // helper variables
      level = 0,
      selected = " selected ";

    // insert the freshly created dropdown navigation after the existing navigation
    element.insertAdjacentHTML('afterend', parselist(element) );

    var nav = document.getElementById(id());

    // autoforward on click
    if (nav.addEventListener) {
      nav.addEventListener('change',goTo);
    }
    if (nav.attachEvent) {
      nav.attachEvent('onchange', goTo);
    }

    return nav;

    function goTo(e){

      // Crossbrowser issues - http://www.quirksmode.org/js/events_properties.html
      var targ;
      if (!e) e = window.event;
      if (e.target) targ = e.target;
      else if (e.srcElement) targ = e.srcElement;
      if (targ.nodeType === 3) // defeat Safari bug
        targ = targ.parentNode; 

      if(targ.value) window.location.href = targ.value; 
    }

    function islist(list){
      var n = list.nodeName.toLowerCase();
      return (n === 'ul' || n === 'ol');
    }

    function id(nextId){
      for(var j=1; document.getElementById('selectnav'+j);j++);
      return (nextId) ? 'selectnav'+j : 'selectnav'+(j-1);
    }

    function parselist(list){

      // go one level down
      level++;

      var length = list.children.length,
        html = '',
        prefix = '',
        k = level-1
        ;

      // return immediately if has no children
      if (!length) {
        return;
      }

      if(k) {
        while(k--){
          prefix += indent;
        }
        prefix += " ";
      }

      for(var i=0; i < length; i++){

        var link = list.children[i].children[0];
        if(typeof(link) !== 'undefined'){
          var text = link.innerText || link.textContent;
          var isselected = '';

          if(activeclass){
            isselected = link.className.search(activeclass) !== -1 || link.parentElement.className.search(activeclass) !== -1 ? selected : '';
          }

          if(autoselect && !isselected){
            isselected = link.href === document.URL ? selected : '';
          }

          html += '<option value="' + link.href + '" ' + isselected + '>' + prefix + text +'</option>';

          if(nested){
            var subElement = list.children[i].children[1];
            if( subElement && islist(subElement) ){
              html += parselist(subElement);
            }
          }
        }
      }

      // adds label
      if(level === 1 && label) {
        html = '<option value="">' + label + '</option>' + html;
      }

      // add <select> tag to the top level of the list
      if(level === 1) {
        html = '<select class="selectnav" id="'+id(true)+'">' + html + '</select>';
      }

      // go 1 level up
      level--;

      return html;
    }

  };

  return function (element,options) {
    selectnav(element,options);
  };


})();

//]]>
</script>
<script type='text/javascript'>
//<![CDATA[

jQuery(document).ready(function(){
  jQuery("#sidebarnbt .widget h2").wrapInner("<span class='sidebar-headline-textnbt'></span>");
  jQuery("#sidebarnbt .widget h3").wrapInner("<span class='sidebar-headline-textnbt'></span>");
  jQuery("#footernbt .widget h2").wrapInner("<span class='footer-headline-textnbt'></span>");
  jQuery("#footernbt .widget h3").wrapInner("<span class='footer-headline-textnbt'></span>");
  
  /* Responzive.js v1.0 */
  selectnav('navnbt');
  selectnav('top-navnbt');
  
});

//]]>
</script>

<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/338641159-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY5Lx-Qp4MSwzbkcIFC_z_W8EmvvEw:1727810478962';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d6759713888282959975','//www-stackoverflow-info.blogspot.com/2016/04/php-mysql-how-to-show-selected-value-on.html','6759713888282959975');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '6759713888282959975', 'title': 'Discussion of Coding', 'url': 'http://www-stackoverflow-info.blogspot.com/2016/04/php-mysql-how-to-show-selected-value-on.html', 'canonicalUrl': 'http://www-stackoverflow-info.blogspot.com/2016/04/php-mysql-how-to-show-selected-value-on.html', 'homepageUrl': 'http://www-stackoverflow-info.blogspot.com/', 'searchUrl': 'http://www-stackoverflow-info.blogspot.com/search', 'canonicalHomepageUrl': 'http://www-stackoverflow-info.blogspot.com/', 'blogspotFaviconUrl': 'http://www-stackoverflow-info.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Discussion of Coding - Atom\x22 href\x3d\x22http://www-stackoverflow-info.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Discussion of Coding - RSS\x22 href\x3d\x22http://www-stackoverflow-info.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Discussion of Coding - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/6759713888282959975/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Discussion of Coding - Atom\x22 href\x3d\x22http://www-stackoverflow-info.blogspot.com/feeds/5029271814498930828/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-7221771530660299', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/a1b26866a6dd2f00', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '5029271814498930828', 'pageName': 'PHP \x26 MySQL - How to Show Selected value on Dropdown Menu', 'pageTitle': 'Discussion of Coding: PHP \x26 MySQL - How to Show Selected value on Dropdown Menu', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': false, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'PHP \x26 MySQL - How to Show Selected value on Dropdown Menu', 'description': 'Blog coding and discussion of coding about JavaScript, PHP, CGI, general web building etc.', 'url': 'http://www-stackoverflow-info.blogspot.com/2016/04/php-mysql-how-to-show-selected-value-on.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 5029271814498930828}}]);
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'headersec', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'mainblogsec', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'mainblogsec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1203661419-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML2', 'mainblogsec', document.getElementById('HTML2'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_AdSenseView', new _WidgetInfo('AdSense1', 'sidebarrightnbt', document.getElementById('AdSense1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'sidebarrightnbt', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'sidebarrightnbt', document.getElementById('HTML3'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_AttributionView', new _WidgetInfo('Attribution1', 'sidebarrightnbt', document.getElementById('Attribution1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_StatsView', new _WidgetInfo('Stats1', 'footersecnbt3', document.getElementById('Stats1'), {'title': 'Total Pageviews', 'showGraphicalCounter': false, 'showAnimatedCounter': false, 'showSparkline': true, 'statsUrl': '//www-stackoverflow-info.blogspot.com/b/stats?style\x3dWHITE_TRANSPARENT\x26timeRange\x3dALL_TIME\x26token\x3dAPq4FmCSJUDscGs5S-J-WoXIHtGEPkUOYIirhKT0cuhwzN7jrGrq5mT3PDzZ9A9Kku_YW2lPL6MDIJtwF7P6U4jmqEzRjlRoGw'}, 'displayModeFull'));
</script>
</body>
</html>
Sunday, April 3, 2016

PHP & MySQL - How to Show Selected value on Dropdown Menu

PHP & MySQL - How to Show Selected value on Dropdown Menu
