Display text from a mysql table like a array

Question

<?php
 mysql_query("SELECT * FROM page where page_id = '$page_id'") or die(mysql_error());

while($land = mysql_fetch_array($resultxx)){

$land =$land['land'];

?>

output $land is NL,DE,BE,AL.. How is it possible to splits the output

example

<?php 
      echo "    
    <select> 
    <option value='NL'>NL</option>
    <option value='DE'>DE</option>
    <option value='BE'>BE</option>
    <option value='AL'>AL</option>
    </select>";

    }
    ?>

$exp = explode(',', $land); and get with echo $exp[0]; explode function — Bora
– Bora, Commented Aug 29, 2013 at 13:25
This question is very vague. The content of $land['land'] = "NL, DE, BE, AL"? Is that what you are saying? OR that the content of $land['land'] = "NL" for one record, "DE" for another, etc.? If it's the first, just use explode(',', $land); — random_user_name
– random_user_name, Commented Aug 29, 2013 at 13:25
i have problems with editing above. but what i mean NL DE BE AL they are <option>NL</option>....... — Yunus Sarikaya
– Yunus Sarikaya, Commented Aug 29, 2013 at 13:29
$exp[0] shows only the first one. how can i put this into a while loop and display all. — Yunus Sarikaya
– Yunus Sarikaya, Commented Aug 29, 2013 at 13:31

Padmanathan J · Accepted Answer · 2013-08-29 13:44:08Z

0

Try This

<?php
 mysql_query("SELECT * FROM page where page_id = '$page_id'") or die(mysql_error());

while($land = mysql_fetch_array($resultxx)){

$land =$land['land'];
$landarray = explode(",",$land);
$count = count($landarray);
echo "<select>";
for($i=0;$i<$count;$i++){
echo '<option value='.$landarray[$i].'>'.$landarray[$i].'</option>';
}
echo "</select>";
}

?>

answered Aug 29, 2013 at 13:44

Padmanathan J

4,6305 gold badges39 silver badges76 bronze badges

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

Collectives™ on Stack Overflow

Display text from a mysql table like a array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related