Global $town,$type;
mysql_connect("localhost","takeaway","tackduck");
mysql_select_db("takeaway");
settype($type,"integer");
$qry="SELECT tbl_town.town_desc from tbl_town WHERE tbl_town.town_id=$town";
$cur=mysql_query($qry);
while($i=mysql_fetch_row($cur))
{$townname=$i[0];
}
if ($type==0)
{$qry="SELECT tbl_company.company_id,tbl_company.company_name,tbl_company.company_type,tbl_company.company_tel from tbl_company INNER JOIN tbl_town ON tbl_company.town_id = tbl_town.town_id WHERE tbl_town.town_id=$town AND tbl_company.enabled=1 Order By tbl_company.company_name";
}
else
{$qry="SELECT tbl_company.company_id,tbl_company.company_name,tbl_company.company_type,tbl_company.company_tel from tbl_company INNER JOIN tbl_town ON tbl_company.town_id = tbl_town.town_id WHERE tbl_town.town_id=$town AND tbl_company.enabled=1 AND tbl_company.company_type=$type Order By tbl_company.company_name";
}
$cur=mysql_query($qry);
while($i=mysql_fetch_row($cur))
{$companyid[]=$i[0];
$companyname[]=$i[1];
$companytype[]=$i[2];
$companyphone[]=$i[3];
$companycount++;
}
$qry="SELECT type_id,type_desc,type_graphic from tbl_company_type Order By type_desc";
$cur=mysql_query($qry);
while($i=mysql_fetch_row($cur))
{$typeid[]=$i[0];
$typename[$i[0]]=$i[1];
$typegraphic[$i[0]]=$i[2];
$typecount++;
}
mysql_close();
?>
Local Take Away for echo $townname; ?> - Take Away Food Online