display value in dd menu.

[Anon]

My PSQL table:
student(id, name, ic, iccolor)

ic_color(code,desc)

|desc | code |

|blue | B |

|red | R |

Example: current value for iccolor field for user x in student table is R that represents red.

What i want: when other user need to modify x iccolor record, the drop down menu
should display RED, but still have BLUE for others to choose.

how to do it? please help.

[snafufans]

hello,

i don't see a problem here.. if u make a dropdown menu from the data in table ic_color this has no effect on the iccolor field a user has in his record. Also in the other direction u can have 1000 records of users with all different color codes but still the table ic_color doesn't chance.. this is just a table with a description and a key for that description... Normaly u use a numeric key for this, but u can use a character if u want.

Greetz,
Snafu

[Anon]

Thats not what i mean.

this is my code.
$query = "select desc,code, iccolor from ic_color, student
WHERE student.iccolor = ic_color.code AND
student.id = '$id'";
$result = pg_exec($link_id,$query);
while (list($icco_desc,$icco_code) = pg_fetch_row($result)) {
print "<option value = \"$icco_code\">$icco_desc</option>\n";

Its only display the current value of user x which is Red without displaying Blue.