0
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "DBNAMES";
?>
<div>
        <?php
            $conn = new mysqli($servername, $username, $password, $dbname);
            if ($conn->connect_error){
                die("Connection failed: " . $conn->connect_error);
            }
            $sql = "SELECT * FROM names";
            $result = $conn->query($sql);

            if ($result->num_rows > 0) {
                echo "Names: ";
                echo "<select name='siteoption'>";
                while($row = mysqli_fetch_array( $result )) {
                    echo '<option value = "'. $row['ID'] . '">' . $row['Name'] . '</option>';
                }
                echo "</select>";
            }
        ?>
</div>

Question: How do i give my drop down a default value that the user can't select?

Exp: <option disabled selected value> -- select an option -- </option> i want to achieve this but in a php echo

NewToPHP
  • 47
  • 1
  • 9

0 Answers0