mutiple selection view in select box

[shanmugamit]

hi,
i am new to this forum.i need help for view a mutiple selected value from database.....th at is already selected value display..

my code.....[php]
$jobcount=count ($vinloc);
print" <td><select name=\"selintlo c[]\" size=\"3\" width=\"25\" class=\"widthed \" multiple=\"mult iple\" tabindex=\"5\"> ";
for($c=0;$c<$jo bcount;$c++)
{
print"<option value=\"$vinloc[$c]\" selected>$vinlo c[$c]</option>";

print"<option value=\"Bangalo re\" ".("Bangalore"= =$vinloc [$c]?"selected=on": "")." >Bangalore</option>";
print"<option value=\"Calcutt a\" ".("Calcutta"== $vinloc[$c]?"selected=on": "" ).">Calcutta</option>";
print"<option value=\"chennai \" ".("Chennai"==$ vinloc[$c]?"selected=on": "" )." >Chennai</option>";
print"<option value=\"Delhi\" ".("Delhi"==$vi nloc[$c]?"selected=on": "" ).">Delhi</option>";
print"<option value=\"Hyderab ad\" ".("Hyderabad"= =$vinloc[$c]?"selected=on": "").">Hyderabad </option>";
print"<option value=\"Kochi\" ".("Kochi"==$vi nloc[$c]?"selected=on": "").">Kochi </option>";
print"<option value=\"Mumbai\ " ".("Mumbai"==$v inloc[$c]?"selected=on": "" ).">Mumbai</option>";
}
[/php]
it display twice the all value......

[harshmaul]

Hi,
Firstly welcome the thescripts :)
Secondly next time please use code tags :(
Thirdly your problem...
You are echoing the options on every iteration of the for loop. You need to re work your logic.
Forthly if you can't work it out, i'm gonna write some code when i get time and you can look at it later.

Thanks :)

[harshmaul]

Hi again, heres some badic code, it might need a spot of debugging as i haven't got apache at work, but i think it should give you at least some direction


[PHP]<?php
//Bangalore loop
$strSelected = "";
for($c=0;$c<$jo bcount;$c++)
{
$strSelected = ("Bangalore"==$ vinloc [$c]?"selected=on": $strSelected);
}?>
<option value="Bangalor e" <?php echo $strSelected ?>>Bangalore</option>

<?php
//Calcutta Loop
$strSelected = "";
for($c=0;$c<$jo bcount;$c++)
{
$strSelected = ("Calcutta"==$v inloc [$c]?"selected=on": $strSelected);
}?>
<option value="Calcutta " <?php echo $strSelected ?>>Calcutta</option>

<?php
//Chennai Loop
$strSelected = "";
for($c=0;$c<$jo bcount;$c++)
{
$strSelected = ("Chennai"==$vi nloc [$c]?"selected=on": $strSelected);
}?>
<option value="Chennai" <?php echo $strSelected ?>>Chennai</option>

<?php
//Chennai Loop
$strSelected = "";
for($c=0;$c<$jo bcount;$c++)
{
$strSelected = ("Delhi"==$vinl oc [$c]?"selected=on": $strSelected);
}?>
<option value="Delhi" <?php echo $strSelected ?>>Delhi</option>[/PHP]

[shanmugamit]

hi harshmaul


it great..Thank you very much.....