<div>
You will need to write a concatenated query.<br />

<pre><code id="code-20-42874997-1">&quot;SELECT type.type, other_value.other_value
FROM type, other_table
WHERE id.type = id.other_table&quot;</code></pre>
</div>


You will need to write a concatenated query.


"SELECT type.type, other_value.other_value
FROM type, other_table
WHERE id.type = id.other_table"

Multitechnician

leakim971

ucohockey

<div>
<div class="content wysiwyg-content">
I have a select dropdown that is populated from a mysql table which is working great. The dropdown is on a update profile page so how do I populate the dropdown from one table but then also get the value that was stored in a different table and show it as selected in the dropdown.<br />
<br />
Here is the code for the dropdown.<br />

<pre><code id="code-10-29147639-1">&lt;select name=&quot;type&quot; id=&quot;type&quot; data-placeholder=&quot;type&quot; class=&quot;form-control form-control-select2 select2-hidden-accessible&quot; data-fouc=&quot;&quot; tabindex=&quot;-1&quot; aria-hidden=&quot;true&quot; required&gt;
													&lt;option value=&quot;&quot; selected&gt;Type&lt;/option&gt;
													&lt;?php
													$type = $link-&gt;query( &quot;SELECT * FROM type&quot; );
													while ( $rows = $vertical-&gt;fetch_assoc() ) {
														$type = $rows[ 'type' ];
														echo &quot;&lt;option value ='$type'&gt;$type&lt;/option&gt;&quot;;
													}
													?&gt;
												&lt;/select&gt;</code></pre>
</div>
</div>


I have a select dropdown that is populated from a mysql table which is working great. The dropdown is on a update profile page so how do I populate the dropdown from one table but then also get the value that was stored in a different table and show it as selected in the dropdown.

Here is the code for the dropdown.
(CODE)

How to show a selected option in a dropdowm from mysql

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.

HTML

jQuery (Core) is a cross-browser JavaScript library that provides abstractions for common client-side tasks such as Document Object Model (DOM) traversal, DOM manipulation, event handling, animation and Ajax. jQuery also provides a platform to create plugins that extend jQuery's capabilities beyond those already provided by the library.

jQuery

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.