StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to create combobox in php mysql?
primarykey
Id
19219379
data
AcceptedAnswerId
20028572
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-10-07T07:42:07.447
FavoriteCount
0
LastActivityDate
2013-11-18T05:31:56.527
LastEditDate
2013-10-07T08:03:28.147
LastEditorUserId
1584286
OwnerUserId
2853548
ParentId
0
PostTypeId
1
Score
-1
ViewCount
2748
LastEditorDisplayName
text
Body
<p>I have a dropdown select that shows mysql records. What I want is to create another dropdown select to have a combobox.</p> <p>bid.php</p> <pre><code><script type="text/javascript" src="javascript/jquery.js"></script> <script> function showUser(str) { var $txtHint = $('#txtHint'); if (str == "") { $txtHint.html(''); return; } $txtHint.load('bid_list.php?q=' + str) } </script> </head> <body onload=showUser(str="ALL")> <div id="main" style="width:1150px;margin:0 auto;padding:10px;"> <div id="title" style="width:1150px;margin:0 auto;text-align:center;font-size:30px;color:gray;text-shadow:2px 2px #000;font-family:Verdana, Tahoma, sans-serif;"><h3>BIDDING LIST</h3></div> <div id="container" style="width:1100px;"> <?php $mysqli = new mysqli("localhost", "root", "", "app"); $result = $mysqli->query("SELECT bid FROM procurement WHERE bid LIKE '13-___' OR bid LIKE '1_-___' OR bid LIKE '2_-___' GROUP BY bid ORDER BY bid"); $option = ''; while($row = $result->fetch_assoc()) { $option .= '<option value = "'.$row['bid'].'">'.$row['bid'].'</option>'; } ?> <div style="text-align:center;"> <select name="users" onchange="showUser(this.value)" style="overflow:scroll;width:100px;"> <option value="ALL" selected='ALL'>ALL</option> <?php echo $option; ?> </select> </div> <br> <div id="txtHint"></div> </code></pre> <p>bid_list.php</p> <pre><code><html> <head> <title></title> <link rel="stylesheet" href="css/style.css" type="text/css" id="" media="print, projection, screen" /> <script type="text/javascript" src="javascript/jquery.tablesorter.js"></script> <script type="text/javascript"> $(function() { $("table").tablesorter({debug: true}); }); </script> <script type="text/javascript"> $(function(){ var tfrow = document.getElementById('tfhover').rows.length; var tbRow=[]; for (var i=1;i<tfrow;i++) { tbRow[i]=document.getElementById('tfhover').rows[i]; tbRow[i].onmouseover = function(){ this.style.backgroundColor = '#f3f8aa'; }; tbRow[i].onmouseout = function() { this.style.backgroundColor = '#ffffff'; }; } }); </script> </head> <body> <?php $mysqli = new mysqli("localhost", "root", "", "app"); $q = $_GET["q"]; $where = ''; if ( $q != 'ALL' ) { $where = " WHERE bid='$q' "; } $result1 = $mysqli->query(" SELECT bid, item_name, item_description, unit, unit_cost, quantity, supplier, po_number, po_date, counter, SUM(unit_cost*quantity) AS total_amount FROM procurement $where GROUP BY counter ORDER BY bid "); echo'<table id="tfhover" cellspacing="0" class="tablesorter" style="text-transform:uppercase;"> <thead> <tr> <th title="Item Name">Item Name</th> <th title="Item Description">Description</th> <th title="Example : Pc, Pcs, Box and Etc.">Unit</th> <th title="Item Price">Unit Cost</th> <th title="Total Item Quantity">QTY</th> <th title="Total Price">Total Amount</th> <th title="Name of Supplier">Supplier</th> <th title="Purchase Order #">PO #</th> <th title="Purchase Order Date">PO Date</th> </tr> </thead>'; echo'<tbody>'; while($row = $result1->fetch_assoc()){ if($row['bid'] != '') { echo'<tr> <td>'.$row['item_name'].'</td> <td>'.$row['item_description'].'</td> <td>'.$row['unit'].'</td> <td>'.number_format($row['unit_cost'], 2, '.', ',').'</td> <td>'.$row['quantity'].'</td> <td>'.number_format($row['total_amount'], 2, '.', ',').'</td> <td>'.$row['supplier'].'</td> <td>'.$row['po_number'].'</td> <td>'.$row['po_date'].'</td> </tr></tbody>'; } } echo "</table>"; if (!$mysqli) { die('Connect Error: ' . mysqli_connect_error()); } mysqli_close($mysqli); ?> </body> </html> </code></pre> <p>What I want to do if the dropdown value is equal to 13-001 the second dropdown shows all po_number, if i choose in 2nd dropdown all the records of po_number like 12-12-CO 397 shows in table. How to do that?</p>
Tags
<php><jquery><mysql><combobox><mysqli>
Title
How to create combobox in php mysql?
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USMichael Schmidt
UserOwnerUserId
1. USaltaire lastname
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POHow to create combobox in php mysql?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTDownMod
CommentsPostId
1. COYou desperately need to learn to separate HTML from SQL. Because mysqli has absolutely nothing to do with whatever combo boxes, which makes your questions unanswerable.
  singulars
  PostPostId
  POHow to create combobox in php mysql?
  UserUserId
  USYour Common Sense

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.