PHP Forum

**alexia_net** · 10-01-2010, 08:58 AM

Hi. I have created a small form with a radio button, textbox and a list on it. When I click on the radio button I want the list to be populated with some records from a database. I do not know what is the problem with my code and I hope someone can help me. I AM VERY NEW WITH PHP.

HTML Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html  xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta  http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled  Document</title>
</head>

<body>

<?php 
require_once($_SERVER["DOCUMENT_ROOT"].'/ITA/DB/OpenDB.php');

function LoadBuildings(){
$strSQL  = "SELECT internalCodeBuilding FROM building";
$result=mysql_query($strSQL) or die("Unable to select the  information!");
echo'<select  name="lstBuilding"><option value=""></option>';

while($rand=mysql_fetch_array($result)){
echo '<option  value='.$rand['internalCodeBuilding'].'</option>';
}
echo'</select>';
}

echo '
<table width="80%"  border="1">
<tr>
<td><p>
<label>
<input  type="radio" name="RadioGroup1" value="building" id="RadioGroup1_0"  onclick="LoadBuildings()";/>
Building</label>


</p></td>
<td>Building name: 
<label>
<input  type="text" name="txtBuildingName" id="txtBuildingName" />
</label></td>
<td>Select building: 
<label>
<select  name="lstBuilding" id="lstBuilding">
</select>
</label></td>
</tr>
</table>
';
?>

</body>
</html>

Thank you.

**orionoreo** · 10-01-2010, 07:01 PM

option tag not closed and labeled

PHP Code:


			
echo '<option  value='.$rand['internalCodeBuilding'].'</option>';

**neeru84** · 10-06-2010, 07:21 AM

Nice code is being posted here it really helps me alot thanx for such a nice post ....