mySql fetch array ignore null value

Question

Here i am populating my dropdowns with database fields using php my code follows,

while ($row = mysql_fetch_array($result)) {
$series1 .= "<option id='Series1' value='" . $row['Series'] ."'>" . $row['Series'] ."             </option>";
}

after fetching i echo it to html

<select id="Series1"  onchange="changeVal('Series1')">
    <option value="">Please select</option>
        <?php echo $series1 ?>
</select>

my problem is i have some null values in the database field, i don't want that to be inserted in the options field. my final result now look like this preview

please help me.

Share your SQL Query, that could help us determine what is going wrong... — Borniet
– Borniet, Commented May 17, 2013 at 6:26
Yup, JW nailed it in fact, don't even need to see the SQL :-) — Borniet
– Borniet, Commented May 17, 2013 at 6:27

Yogesh Suthar · Accepted Answer · 2013-05-17 06:26:51Z

4

Try this

while ($row = mysql_fetch_array($result)) {
   if($row['Series'] != '' || $row['Series'] != NULL) {
       $series1 .= "<option id='Series1' value='" . $row['Series'] ."'>" . $row['Series'] ."             </option>";
   }
}

OR

In your sql query

SELECT * FROM your_table WHERE Series IS NOT NULL

answered May 17, 2013 at 6:26

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

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

Comments

Rajendra Yadav · Accepted Answer · 2013-05-17 06:30:07Z

2

You can try like this

  while ($row = mysql_fetch_array($result)) {
  if(isset($row['Series'])) {
   $series1 .= "<option id='Series1' value='" . $row['Series'] ."'>" . $row['Series'] ."             </option>";
        }
      }

answered May 17, 2013 at 6:30

Rajendra Yadav

6353 silver badges12 bronze badges

Comments

user2361114 · Accepted Answer · 2013-05-17 06:33:21Z

1

Try this...

<select id="Series1"  onchange="changeVal('Series1')">
    <option value="">Please select</option>


    <?php
while ($row = mysql_fetch_array($result)) 
{
    if($row['Series'] != '' || $row['Series'] != NULL) 
     {
?>
      <option value="<?php echo $row['Series']; ?>"><?php echo $row['Series']; ?></option>  
</select>



<?php
     }
}
?>

answered May 17, 2013 at 6:33

user2361114

1621 gold badge1 silver badge9 bronze badges

Collectives™ on Stack Overflow

mySql fetch array ignore null value

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related