Populating dropdown list

[micmac]

Hi,
Can anyone tell me where i am going wrong?
The table structure looks like this:
I have a table called intranet. This has a field called building_id. This value is a number which represents the name of a building.
In another table called building, the auto incrememted field is called building_id. This field is the link to the intranet table and all of its other fields.
Here is the code:

<?
// create SQL statement
$sql = "SELECT * FROM building, intranet WHERE building.building_id=intranet.building_id AND intranet.CatID=$id";

// execute SQL query and get result
$sql_result = mysql_query($sql)
	or die("Couldn't execute query.");

// put data into drop-down list box
while ($row = mysql_fetch_array($sql_result)) {

$bname  = $row["building_id"];
$bwas  = $row["b_name"];
$option_block .= "<OPTION value=\"$bname\">$bwas</OPTION>";
}

?>

...and the output

<SELECT  name="operating_system">

<? echo "$option_block"; ?>

</SELECT>

At the moment it is getting the correct value from the DB but i need it to get the other names of the buildings as well so that the user can update the building if they wish.

[bav]

do you mean it's outputting only one name of the building in the pull-down menu?

[micmac]

That's correct...i need it to display all those names in the building table but have selected the building_id value that relates to the id.
At the moment it is just showing the one value...not the other names.

[bav]

Try this:

$result = "SELECT * FROM building, intranet WHERE building.building_id=intranet.building_id AND intranet.CatID=$id";

$number = mysql_num_rows($result);
if($number) {

$option_block = "";
$option_block .= "<SELECT  name=\"operating_system\">";
for($i=0; $i<$number; $i++)  {

   $bname = mysql_result($result, $i, "building_id");
   $bwas  = mysql_result($result, $i, "b_name");

 $option_block .= "<OPTION value=\"$bname\">$bwas</OPTION>";

}
$option_block .= "</select>"; 

}

[KoshNaranek]

ok... here is my way...

<?php
function kategorien_zeigen(){
    /** Liste der Hardwarekategorien (Typen) laden   **/
    $abfrageH="select * from HIS_Kategorien order by Kategorie;";
    $resultH=mysql_query($abfrageH);
     while ($row = mysql_fetch_object($resultH)){
        $Hid=$row->id;
        $Hkurz=$row->Kategorie;
        echo "<option value='$Hid'>$Hkurz</option>";
    }
}
?>

<!/* .bla bla bla */>


<select name="Kategorie">
<!      /* find name for the single entry */  >
     <? $abfrage2="select * from HIS_Kategorien where id='$findekategorie';";
           $result2=mysql_query($abfrage2); ?>
        <option value='<?=mysql_result($result2,0,'id')?>'><?=mysql_result($result2,0,'Kategorie')?></option>
<!         /* call the function to load ALL options */ >
        <? kategorien_zeigen(); ?>
        </select>