Need to have to table x 9 but get only 1

[netrepsa]

Could anyone tel me what i did wrong?

I have 9 provinces in SA and would like to display the map of each province and then the information about that province.

I use two tables
1. region
2. area

When I exclude the area detail all 9 show.
Like this only the first one show.

   <td width="575" valign="top" bgcolor="white">
	<table WIDTH="575" border=1 CELLPADDING="2" CELLSPACING="2">
	<tr>
		<td COLSPAN=6 align="center">
		<font face="Verdana" size="4"><b>Sewing with Pride South Africa </b></font><font face="Verdana" size="7"><br></font> <br>
		<font face="Verdana" size="2"><b><img src="sa_map.jpg" border="0"></b></font>
		</td>
		</tr>
		<?php
		include "/home/xxx/public_html/connect.inc";

		$result = mysql("sewing_swp","SELECT * FROM region WHERE ID<30");

		while ($myrow = mysql_fetch_row($result)) {

		$map=$myrow[5];
		$descrip=$myrow[2];
        $prov = $myrow[4];
        $land = $myrow[3];
        $id = $myrow[0];
		$managersid = $land.$id.$prov
		?>			

		<tr>
		<TD colspan=6 ALIGN="center">
		<IMG SRC="<? echo $map ?>" ALT="" WIDTH="425" HEIGHT="277" BORDER="0"><br>
		<font size="4" color="black"><b><? echo $descrip ?></b></font><BR>			
		<font size="4" color="black"><b><? echo $managersid ?></b></font><BR>
		</td>
		</tr>

		<TR>
		<TD VALIGN="top" ALIGN="center">Area</TD>
		<TD VALIGN="top" ALIGN="center">Region</TD>
		<TD VALIGN="top" ALIGN="center">City</TD>
		<TD VALIGN="top" ALIGN="center">Suburb</TD>
		<TD VALIGN="top" ALIGN="center">Status</TD>
		<TD VALIGN="top" ALIGN="center">Book Now</TD>			
		</TR>
		<tr>
		<?php
		include "/home/xxx/public_html/connect.inc";
		$result = mysql("sewing_swp","SELECT * FROM area WHERE managersid='$managersid'");
		while ($row = mysql_fetch_row($result)) {
		?>
		<TD><font SIZE="2"><b><? echo $row[2] ?></b></font></TD>
		<TD><font SIZE="2"><b><? echo $row[1] ?></b></font></TD>
		<TD><font SIZE="2"><b><? echo $row[3] ?></b></font></TD>
		<TD><font SIZE="2"><b><? echo $row[4] ?></b></font></TD>
		<TD><font SIZE="2"><b><? echo $row[5] ?></b></font></TD>
		<?php
         if ($row[5]=='AVAILABLE') {
		 ?>				
		<TD><font SIZE="2"><b><A HREF="application.php?managerid=<? echo $row[1] ?>&areaid=<? echo $row[2] ?>">Book Now</A></b></font></TD>
        <?PHP
    	   }
    	?>	
		</TR>
    <?PHP
		}
	}
	?>
	</TABLE>
   <p align="center"><font face="Arial" size="1">© COPYRIGHT 2004 ALL RIGHTS
    RESERVED [url]www.swp.co.za[/url]</font>
</td>

[Weedpacket]

My guess would be that it's because you're trying to store both sets of results in the same variable $result: as soon as you run the second query it trashes the results of the first. Try putting them in different variables ($region_result and $area_result, say).

<font> tags! EEeewwww.....