Global $county;
mysql_connect("localhost","takeaway","tackduck");
mysql_select_db("takeaway");
$qry="SELECT tbl_town.town_id,tbl_town.town_desc from tbl_town INNER JOIN tbl_county ON tbl_town.county_id = tbl_county.county_id WHERE tbl_county.county_desc='$county' Order By tbl_town.town_desc";
$cur=mysql_query($qry);
while($i=mysql_fetch_row($cur))
{$townid[]=$i[0];
$townname[]=$i[1];
$towncount++;
}
mysql_close();
?>
Local Take Away for echo $county; ?> - Take Away Food Online
include ("header.php");
?>
Select a Town in echo $county; ?> :
if ($towncount==0)
{echo '
';
echo '';
echo 'There are no Towns listed for ';
echo $county;
echo '';
echo '