选择表单的基本填充

Question

Basically trying to populate a drop-down select bar from a table called "Cars" with data in the "VIN" column. It's giving me a blank.

<form>
    <label>VIN:</label>
    <select name="formVIN">
    <?php
        $sql = "SELECT VIN FROM Cars";
        $result = mysql_query($sql);
        while ($row = mysql_fetch_array($result)) {
            echo "<option value='" . $row['VIN'] . "'>" . $row['VIN'] . "</option>";
        }
        echo "</select>";
    ?>
</form>

I would like to take it a step further by displaying ONLY the VIN's of those cars not sold. I have a column in the table "Cars" that has either a 'Y' or 'N' if sold. So I would like it to show only the ones with 'N' as well.

Answer 1

$sql = "SELECT VIN FROM Cars WHERE VSold='N'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
    echo "<option value=" . $row["VIN"] . ">" . $row["VIN"] . "</option>";
}
} else {
echo "<option value=''>ALL SOLD</option>";
}

Figured I'd try a different approach, and while the WHILE did make sense, this isn't too bad either. I'm still learning, a lot, and some of your comments helped me see things from a different perspective. I tried a lot of different options, thank you all.