php repeat one value twice in the while loop (if possible)

Question

I have this table:

emailtype:
emailtypeID      emailtype
1                 primary
2                 secondary
3                 old

I have this code to show emails in the input form:

  $sql = "SELECT * from emailtype";
  $result = $conn->query($sql);
  while($row = $result->fetch_assoc()) { 
         echo 'Email <input type="hidden" name="emailtype[]" id="" value="' . $row["emailtypeID"] . '"/>'  . $row["emailtype"];
        echo '<input type="text" name="email[]" id="" /><br />';            }

GOAL:

I would like to repeat twice the emailtypeID = 2 or emailtype = secondary, so that I can enter two email addresses with the secondary ID.

Is it possible in the while loop?

Thanks!

SOLUTION:

For anybody who needs it, this is the new code as per the Marc B suggestion.

 while($row = $result->fetch_assoc()) { 
      echo 'Email <input type="hidden" name="emailtype[]" id="" value="' . $row["emailtypeID"] . '"/>'  . $row["emailtype"];
      echo '<input type="text" name="email[]" id="" /><br />';
    if($row["emailtype"] == 'secondario'){
        echo 'Email <input type="hidden" name="emailtype[]" id="" value="' . $row["emailtypeID"] . '"/>'  . $row["emailtype"];
         echo '<input type="text" name="email[]" id="" /><br />';
    }

}

thanks! Marc! Sorry, but where exactly should go the if condition? — codeispoetry
– codeispoetry, Commented Jan 22, 2016 at 16:22

Atif Tariq · Accepted Answer · 2016-01-22 16:38:38Z

1

Please use this:

while($row = $result->fetch_assoc()) { 
      echo 'Email <input type="hidden" name="emailtype[]" id="" value="' . $row["emailtypeID"] . '"/>'  . $row["emailtype"];
      echo '<input type="text" name="email[]" id="" /><br />';
    if($row["emailtype"] == 'secondario' || $row["emailtypeID"]==2){
        echo 'Email <input type="hidden" name="emailtype[]" id="" value="' . $row["emailtypeID"] . '"/>'  . $row["emailtype"];
         echo '<input type="text" name="email[]" id="" /><br />';
    }   

    }

answered Jan 22, 2016 at 16:38

Atif Tariq

2,7701 gold badge31 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

php repeat one value twice in the while loop (if possible)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related