calling values from database to dropdown list, doesn't show all the values

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 } ?>

can you show me the value here from DB from which it is not displayed — black
– black, Commented Apr 23, 2016 at 5:51
ya give me a sec .. i'll screenshot the table and the output — Deee9994
– Deee9994, Commented Apr 23, 2016 at 5:51
@Deee9994 if you do print_r($row), what output do you get? Can you post it in your question too please? — Webeng
– Webeng, Commented Apr 23, 2016 at 5:54

Niklesh Raut · Accepted Answer · 2016-04-23 05:54:36Z

1

Change here, missing closing double quote "

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

answered Apr 23, 2016 at 5:54

Niklesh Raut

34.9k17 gold badges82 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Niklesh Raut Over a year ago

happy to help you.

MatthewS · Accepted Answer · 2016-04-23 06:00:23Z

0

You are missing the closing quote after your option value. So it takes two times through before it closes the value. Therefore, only half your rows are showing.

<?php
$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 } ?>

answered Apr 23, 2016 at 6:00

MatthewS

611 silver badge9 bronze badges

Collectives™ on Stack Overflow

calling values from database to dropdown list, doesn't show all the values

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related