从数据库调用值到下拉列表，不显示所有值

Question

i have a table in my database called categorys, it has two columns cat_id and cat_name ,, i finally managed to get the select right but it doesn't show all of the table rows, there's 22 row it only shows 11 of them ! how can i fix that ? here's the code i used

    $sql = "SELECT cat_id, cat_name FROM categorys";
    $result = $conn->query($sql);

    ?>  

    <select name="taskOption">
    <?php if ($result->num_rows > 0) {
 while($row = $result->fetch_assoc()) { ?>
  <option value="<?php echo $row['cat_id']; ?>>
<?php echo $row['cat_name']; ?>
 </option> <?php } ?>
</select> 
<?php } ?>

Answer 1

Change here, missing closing double quote "

<option value="<?php echo $row['cat_id']; ?>">