troubleshooting Question

Display SPECIFIC Rows in SQL Database

Avatar of Mark Miles
Mark MilesFlag for United States of America asked on
Microsoft SQL ServerProgrammingPHP
6 Comments1 Solution16 ViewsLast Modified:

I have an SQL database with 6 columns.  The data in this column is displayed on the front end of a website.  How do I add a "display" column to the table where I can turn off and on whether that specific row is displayed on the front end of the website? 



Here is my code..

<div class="mb-3">
                 <!--                 <input type="text" class="form-control" id="omt" name="omt" placeholder="Old Mask">                -->                <select class="maskSelection form-control rt-select" name="omt" multiple="single" required>                      <option value="" disabled selected>Please select mask the patient is returning</option>                   <?php foreach($mask as $m):?>                      <option value="<?php echo $m->bt_item_id; ?>,<?php echo $m->mask_manufacturer;?>,<?php echo $m->mask_approx_cost;?>" ><?php echo $m->mask_name;?></option>                   <?php endforeach;?>                                  </select>               </div>               <div class="mb-3">                 <!-- <input type="text" class="form-control" id="nmt" name="nmt" placeholder="New mask"> -->                                <select class="maskSelection form-control rt-select" name="nmt" multiple="single" required>                   <option value="" disabled selected>Please select mask you are issuing the patient</option>                   <?php foreach($mask as $m):?>                      <option value="<?php echo $m->bt_item_id; ?>"><?php echo $m->mask_name;?></option>                   <?php endforeach;?>                                  </select>
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros