drop down selected

slimjim

I need show the selected group name.

Need to show that selected...
$hid==$cid==$top

Hope I explain this correctly. been beating my head trying to figure this out.

//
   $sql="select * from links where id='$id' and user_id='$user'"; 
   $result=mysql_query($sql); 
   while ($row=mysql_fetch_array($result)) { 
    $hid=$row["id"];
    $top=$row["topic"];
}

$options="";
$sql="SELECT id, topic FROM groups order by id"; 
$result=mysql_query($sql); 
while ($row=mysql_fetch_array($result)) { 

$cid=$row["id"]; 
$group=$row["name"];
$options.="<OPTION VALUE=\"$cid\">".$group.'</option>';
}

<SELECT NAME=group>
<OPTION VALUE=0>Chose one
<? echo $options; ?>
</SELECT>

Blulagoon

We all write things slightly differently, but this bit of code might help you. Apologies that I don't know how to put it into a nice little code box ......

<form action="bookings1.php" method="post" name="myform">
<select size='4' name='venue_id' style='font-family: verdana; font-size: 10pt; color: #f5a00c; background: #000000'>
<option selected value='0'>Please Select the venue:
<option value='99999'>None of the below
<?php
$query1="SELECT venue_id,venue_name FROM nsa_venue";
$result1=mysql_query($query1);

while($row1 = mysql_fetch_array($result1)) {
$key1 = $row1['venue_id'];

echo "<option value='$key1'>".$row1['venue_name'];
}

This generates a drop down list of venues, showing the venue_name to the user but returning the value of the venue_id for processing. The first item on the list is hard coded, "Please select" and is the selected item. The second item, also hard coded, is "none of the below" and returns the value 99999 which takes the user to a page to enter a new venue.

Then it searches the nsa_venue table for venue names and ids for the user to select.

HTH - Blu

slimjim

Guess I didnt explaine correctly..

I have two tables, one table is list of groups, and each group name has an id, i also have another table, which holds the id of the group from first table.

I need to show the selected group list from first table, but highlighting the selected choice from second table.

But only first table hold the id, and name, while the second table only holds the id of the group name.