$sql = "select * from organization order by
regionalrequirement,organizationname";
$result = mysql_query($sql);


while ($row=mysql_fetch_array($result))
{


// $organizationnameinchinese="";
// if this line was not included .. the value 
// $organizationnameinchinese would not get the new value
extract ($row,EXTR_OVERWRITE);


echo "The school listed are


<A href=vieworganization.php?orgid=$id>$organizationname
</a>

$organizationnameinchinese<BR><BR>";
}