How do I get entries in a MySQL table into a drop-down selection list?
I have a table with entries of people and info about each person. I want to be able to select a person, but I can’t figure out how to make a form that will include everyone within the table and update when new people are added. Thanks!
I’m using a MySQL for the database, with php and html for the website itself.
Ok…you told us what database you are using, but not what programming language you are using for your form. But that’s the important part. The answer is probably about the same if you are using MSSQL or Oracle.
So….What language are you writing your form in?
Is this a desktop or Web app?
What OS are you writing this for?
ETA: In that case (PHP)…You would populate the drop-down by doing a SELECT person from people sort of statement, and looping over the result set.
You can’t update it on the browser when new people are added, unless you are willing to take a deep dive into AJAX. But it will reload on each page refresh with current data, which is usually good enough.
Chiropractic Generation: Drop Table Adjustment.mp4
|
|
Casino Poker Table Money Toke Drop Box Boxes Blackjack $36.98 |
|
|
Antique Queen Anne Pad Foot Drop Leaf Table c1750s $1,809.50 |
|
|
42″ Contemporary White / Natural Round Dual Drop Leaf Pedestal Dining Table Wood $213.99 |
|
|
Safavieh Soren Drop Leaf Pub Table in Dark Espresso (Set of 3) AMH8504A $319.00 |
|
|
10 LARGE AMBER CRYSTAL DROP CANDELABRA 20″ TALL WEDDING TABLE CENTERPIECES $149.50 |
|
|
6 LARGE AMBER CRYSTAL DROP CANDELABRA 20″ TALL WEDDING TABLE CENTERPIECES $94.50 |
|
|
Wells Drop In Single One Well Pan Warmer Steam Table MOD-100TD $299.00 |
|
|
Wells Drop In Single One Well Pan Warmer Steam Table SS-276ULTD $299.00 |
|
|
A3BS Basic Drop Table $1,099.99 |
|
|
A3BS Basic Drop Table $1,099.99 |
|
|
A3BS Basic Drop Table $1,099.99 |
|
|
A3BS Basic Drop Table $1,099.99 |
|
|
Marlboro Leather and wood table Ashtray Mint Price drop $9.99 |
|
|
MAPLE DROP LEAF DINING TABLE #2025 $275.00 |
|
|
CHIROPRACTIC TABLE ASHWORTH BIO 8000 ELEVATING 5 DROPS BREAKAWAY $2,395.00 |
|
|
Reeded Legs / Elephant Foot British Oak Antique Drop Leaf Table Gate Kitchen $385.00 |
|
|
RV INTERIOR ~ DROP LEAF TABLE SUPPORT ~ ZINC $9.00 |
|
|
Antique Victorian Quartered Oak Tobey Furniture Drop Leaf Dining Table C1900 $1,450.00 |
|
|
Vtg 1950 Conant Ball Drop Leaf Dining Table Maple 8 ft $995.00 |
|
|
Vintage England Wood Folding Drop Table $875.00 |
|
|
HILL ADJUSTABLE TABLE WITH PELVIC DROP AND ELEVATION $2,500.00 |
|
|
Barbie Size 2 Side Drop Leaf Dining Room Table Wood Grain Look Top Pedestal VGC $5.00 |
|
|
Drop Leaf Table Support, 9-3/4″ – Part #84071 $10.29 |
|
|
Contemporary Glass Drop Table Lamp, Striped Polyresin Bedside Light Accent Pair $115.95 |
|
|
Antique Solid Cherry Round Drop Leaf Dining Table $2,505.00 |
|
|
ZEINTH II 210 HYLO TABLE WITH PELVIC DROP $5,500.00 |
|
|
Awesome Antique English Oak Drop Leaf Table Oval/Skinny $495.00 |
|
|
MID CENTURY DROP LEAF TABLE + 2 LEAVES $475.00 |
|
|
Colonial Drop Front End Table,Pick- up LONG ISLAND NY $20.00 |
|
|
1800′s American Walnut Drop Leaf Table Spindle Legs Beautiful Patina! Must See $2,500.00 |
|
|
John Boos Drop Leaf Kitchen Island Bar 48×32 Table KIB01-O KIB & Cutting Board $1,249.00 |
|
|
Outdoor Teak Patio Furniture Drop Leaf Table $399.99 |
|
|
SWC-Chippendale Oval Drop Leaf Table, Salem, c.1780 $8,500.00 |
|
|
Randell 9550A Drop In Freezer Plate Chiller Dipping Cabinet w/ SS Table $1,199.00 |
|
|
Nanatsuiro Drops anime door game floor table play mat $39.99 |
|
|
ANTIQUE INDUSTRIAL METAL TYPEWRITER ROLLING TABLE WITH DROP SIDES $19.99 |
|
|
Teak Pull Out Drop Leaf Table $500.00 |
|
|
96″ 10 PLAYERS POKER TABLE w/ SUITED FELT + DROP BOX BLACK $318.00 |
|
|
Casino Poker Table Steel Money Drop Box $88.98 |
|
|
ANTIQUE PRIMITIVE 1800 CARVED WOOD AMERICAN SHAKER CHILD’S DOLL DROP LEAF TABLE $349.99 |
|
|
Jura Cleaning Tablets for all Capresso and Jura-Capresso Automatic Coffee Centers, Pack of 6 $19.00 Designed for use with all Capresso and Jura-Capresso automatic coffee centers, this pack of six specially formulated cleaning tablets removes inner oil build-up. The machine’s display will indicate when it’s time to run a cleaning cycle (after every 200 cups of coffee), and it only requires one tablet each time. Simply drop a tablet into the bypass doser and run the cleaning cycle. Using the table… |
|
|
Norpro Stainless Steel Scoop, 25MM (1.5 Teaspoon) $11.32 Perfect for making melon balls or scooping small dollops of ice cream, cookie dough, butter, frozen yogurt, or sherbet, this 1.5-teaspoon scoop is crafted of 18/8 stainless steel and features spring action for easy use. Simply scoop the food, and then squeeze of the handle to release it. The scoop will yield roughly 140 scoops from a quart of ice cream. After the fun is over, simply stick it in th… |
|
|
Winsome Wood Windsor Chair, Natural, Set of 2 $67.98 Quality built Windsor chair. Solid wood construction. Fully assembled. Smooth Contour seat comfort seating. … |
|
|
The Best Of Conscious Roots (2CD) $29.90 Conscious Roots comprises a mixture of classic roots, fused styles, genre busters and beautiful raw acoustic songs. It showcases the fertile roots music scene in New Zealand. The philosophy of this compilation series is that we should give voice to the spirit within and develop our own roots genre rather than following overseas musical trends. The 30 tracks on ‘The Best of Conscious Roots’ bring t… |
Incoming search terms:
- chiropractic drop