query($query); // Generate HTML of state options list if($result->num_rows > 0){ echo 'Select Barangay'; while($row = $result->fetch_assoc()){ echo ''.$row['brgy'].''; } }else{ echo 'Barangay not available'; } } ?>