Databases
StackOverflow2013
Postsdbo
POHighlight already selected items in multiple select box
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHighlight already selected items in multiple select box
    text
    copied!<blockquote> <p>I have 2 tables one 'brand' that stores all the brand names and 'brand_category' that stores all the brand names with their corresponding categories. I have a multiple select box that loads all the items in the 'brand' table when the page loads, but I need to highlight the items that are already submitted by the user previously in the 'brand_category' table with the rest of the brands that are left so that the user knows what are the brands left to be entered in the 'brand_category' table. Below is the code but it doesn't work. Please help to resolve this issue</p> </blockquote> <pre><code>&lt;div class="selectbox"&gt; &lt;label id="brand" class="brand_label"&gt;Brand:&lt;/lable&gt; &lt;?php echo "&lt;select name='brand' class='cat_brands' multiple&gt;" &lt;option value='0'&gt;None&lt;/option&gt;"; $query = mysql_query("SELECT id, name FROM brand"); while($br_query = mysql_fetch_assoc($query)){ $query_select = mysql_query("SELECT * FROM brand_category WHERE brand_id='".$br_query['id']."'"); while($brnd_select = mysql_fetch_assoc($query_select)){ if($brnd_select['brand_id']==$br_query['id']){ echo "&lt;option style='background-color: red' value='".$br_query['id']."'&gt;".$br_query['name']."&lt;/option&gt;"; } } } ?&gt; &lt;/div&gt; </code></pre> <blockquote> <p>The above code only displays the brands entered in the 'brand_category' table rest of the brands are not displayed. I need to display them also.</p> </blockquote>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload