TypeID; $propertytypename=$row->Type; $propertytypeids[$i] = $propertytypeid; $propertytypenames[$i] = $propertytypename; $i++; } $query="select * from exchangerate order by CurrencyType"; $result=mysql_db_query ($db,$query)or die ('invalid request found'); $first = ""; $firstexrate = ""; $cids = array(); $ctypes = array(); $exrates = array(); $i=0; while ($row = mysql_fetch_object($result)){ $cid=$row->CurrencyID; $ctype=$row->CurrencyType; $exrate = $row->CurrencyRate; if($first == ""){ $first = $ctype; $firstexrate = $exrate; } $cids[$i] = $cid; $ctypes[$i] = $ctype; $exrates[$i] = $exrate; $i++; } $query="select * from parish"; $result=mysql_db_query ($db,$query)or die ('invalid request found'); $parishids = array(); $parishnames = array(); $i=0; while ($row = mysql_fetch_object($result)){ $parishid=$row->ParishID; $parishname=$row->ParishName; $parishids[$i] = $parishid; $parishnames[$i] = $parishname; $i++; } include("tpl_advanced.php"); ?>