| Area:
print mysql_result($query,0,LocMetroName);
?> |
if(mysql_result($query,0,LocCountID)==1 OR mysql_result($query,0,LocCountID)==2 OR mysql_result($query,0,LocCountID)==4)
{
if(mysql_result($query,0,LocCountID)==1 OR mysql_result($query,0,LocCountID)==4)
print "State: ";
if(mysql_result($query,0,LocCountID)==2)
print "Province: ";
$state=mysql_result($query,0,LocStateID);
$newquery=mysql_query("SELECT LocStateName FROM locstates WHERE LocStateID=$state");
print mysql_result($newquery,0);
}
?> |