[RESOLVED] ajax database dropdown

Thikho

I have a form which have branches and when the user select the branch name i want it to show the other branch info like tel, fax etc

I am able to do it like this but the problems is when i add the branch to the database

<tr>
<td><b>Branch:</b></td><td>

<select name="branches" onchange="showBranch(this.value)">
		<option selected>Select Centre</option>
		<option value="BFN">Bloemfontein</option>
		<option value="CPT">Cape Town</option>
		<option value="DUR">Durban</option>
		<option value="ELS">East London</option>
		<option value="GRJ">George</option>
		<option value="JNB">Johannesburg</option>
		<option value="KIM">Kimberley</option>
		<option value="NLP">Nelspruit</option>
		<option value="PMB">Pietermaritzburg</option>
		<option value="PTG">Polokwane</option>
		<option value="PLZ">Port Elizabeth</option>
		<option value="PRY">Pretoria</option>
		<option value="RTB">Rustenburg</option>
		<option value="VAAl">Vaal Triangle</option>
		<option value="CWHS">CPT Warehouse</option>
		<option value="PWHS">PTA Warehouse</option>
		<option value="WHS">JHB Warehouse</option> 

</select>
</td>

</tr>
<tr><td valign="left-align" height="10" width="100%">
		<div id="txtHint"></div>
            </td></tr>

But i wnat to do it this way without hardcoding

<td><b>Branch:</b></td><td><select name='branches' onchange="showBranch(this.value)">
<?php
include('connection.php');
$Qxo="select * from Branch_Information ORDER by Branch asc";
print "<option>Select Branch</option>";

$cat=mysql_query($Qxo) or die ("cannot select from Branch Information");
while ($list=mysql_fetch_array($cat))
{

print "<option value='$list[Branch_Name]'>$list[Branch_Name]</option>";
}
?>
</select></td>
</tr>
<tr><td valign="left-align" height="10" width="100%">
		<div id="txtHint"></div>
            </td></tr>

djwideboy

I would drop in and out of php a little more. try this
<td><b>Branch:</b></td><td><select name='branches' onchange="showBranch(this.value)">
<?php
include('connection.php');
$Qxo="select * from Branch_Information ORDER by Branch asc";
print "<option>Select Branch</option>";

$cat=mysql_query($Qxo) or die ("cannot select from Branch Information");
while ($list=mysql_fetch_array($cat))
{
?>
<option value="<?php echo $list["Branch_Name"] ; ?>"><?php echo $list["Branch_Name"]; ?></option>
<? php } ?>
</select></td>
</tr>
<tr><td valign="left-align" height="10" width="100%">
<div id="txtHint"></div>
</td></tr>

Thikho

Thanks i have done that but the ajax part its not working when i select the branch name the details are not showing whereas in the first example its working fine.