Page 1 of 1

combo box select problem

Posted: Fri Jul 18, 2003 9:35 am
by zuzupus
hi,

i am getting value of project from database

Code: Select all

<?php
$query = "SELECT kunde,projektnr from emp_kunde";
$result = mysql_query($query) or die("Query failed: $query");
$projekt = array();
while ($row = mysql_fetch_assoc($result))
{
array_push($projekt, $row["projektnr"]);
}
$hprojekt = array_unique($projekt);
?>
<form >
<td align="center">
<select name="projekt">
<? foreach($hprojekt as $value) { ?>
<option value="<?= $value ?>"><?= $value ?></option>
<? } ?>
</select>
</td>

<?= $line["projekt"] ?>//this is for printing

</form>

let say the value for project combo box is

Apple,Mango so when i select mango from project field and then submit the form i will get mango as printed value,i want mango must be shown selected in new line,whatever i select it will be shown as selectd on next new line,but in my case always Apple as selected in new line

let say in my list
1.Dad
2.Mom
3.Didi //if i select didi from this field then new line should be didi
4.Uncle as selected
5.Aunty

but above code always shown as Dad selected,

how i cna get selected item as shown in new line

thanks

Posted: Fri Jul 18, 2003 9:40 am
by twigletmac
Please edit your post to add in for the code so that it is easier to read.

Mac

Posted: Mon Jul 21, 2003 12:02 pm
by RedRasper
Try using <option selected> in your combo box. The first item is automatically selected if you don't specify one.

You need to do an if statement to check if the item was the same as the one selected. (It also means you need to either post/get the item when you submit.)

Hope thats of some help?

RedRasper