<script src="http://code.jquery.com/jquery-1.5.min.js"></script> <script> $(document).ready(function () { var $article = null; var $business = null; $('#category').change(function () { var categoryName = $('#category').val(); if ($article == null) { $article = $('<h4>Select a business you wish to view.</h4><select id="article" name="article"> <option value="0">Select A Business To View Listing</option> </select>').appendTo('.query'); } }); }); </script>
<?php $con = mysqli_connect(,,,,); // Check connection if (mysqli_connect_errno()) { echo "<option>Failed to connect to MySQLi</option>" ; } $result = mysqli_query($con,"SELECT Bname FROM Business WHERE Category='$('#category').val(); ' "); while($row = mysqli_fetch_array($result)) { echo "<option value='".$row['Bname']."'>".$row['Bname']."</option>"; } // Free result set mysqli_free_result($result); mysqli_close($con); ?>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)