[RESOLVED] populating drop down

[slimjim]

How do I do this drop down box ?
Making an edit page.

I have 2 tables
groups
id || categoryname

program

id || cateogry_id

I need to populate the groups in it at same time show the selected choice from program

Not showing id but needs to show categoryname with of course the values being the id of groups

Hope this makes sence

[slimjim]

I solved it myself.

$sql1="select * from groups"; 
$res=mysql_query($sql1); 
while($obj=mysql_fetch_object($res)) 
{ 
$categoryid=$obj->id; 
$groupname=$obj->topic; 
$sel=""; 
if($categoryid==$group_id)$sel=" selected ";//and group_id come from program category_id 
print "<option value='$categoryid' $sel>$groupname</option>"; 
}