|
VENTURE CAPITAL DIRECTORY
";
$mode=1;
}
else
{
$mode=$_GET['mode'];
if (($mode==1)||($mode==2)||($mode==3)||($mode==4))
{
}
else
{
$mode=1;
}
}
if ($mode==1)
{
$result=mysql_query("select institution.institution , vcsbn.website from vcsbn join institution where vcsbn.institution=institution.institution group by institution.institution order by institution.institution;",$link);
$view="Institutions: ";
while ($data=mysql_fetch_row($result))
{
if($data[1]!="")
{
$view=$view."| $data[0] | ";
}
else
{
$view=$view."| $data[0] | ";
}
}
$view=$view." ";
display();
}
if($mode==2)
{
//echo"this point never reached";
if(!isset($_GET['region']))
{
$result=mysql_query("select region,regionid from region order by region",$link);
$view="Region ";
while ($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
}
else
{
$region=$_GET['region'];
$result=mysql_query("select region from region where regionid='$region'",$link);
$data=mysql_fetch_row($result);
$regionname=$data[0];
$view="Regional Specialty:$regionname ";
if((!isset($_GET['industry']))&&(!isset($_GET['country']))&&(!isset($_GET['city'])))
{
$view=$view." Industries: ";
$result=mysql_query("select d.industry,d.industryid from region as a, regionvc as b, industryvc as c, industry as d
where a.regionid=b.regionid and b.vcid = c.vcid and c.industryid = d.industryid and a.regionid='$region' group by d.industry",$link);
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
$view=$view."Country Head Quarters ";
$result=mysql_query("select d.country,d.countryid from region as a, regionvc as b, countryvc as c,country as d
where a.regionid=b.regionid and b.vcid=c.vcid and c.countryid=d.countryid and a.regionid='$region' group by d.country",$link );
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
}
elseif((isset($_GET['industry']))&&(!isset($_GET['country'])))
{
$industry=$_GET['industry'];
$result=mysql_query("select industry from industry where industryid='$industry'",$link);
$data=mysql_fetch_row($result);
$industryname=$data[0];
$view=$view."Industry:$industryname ";
$view=$view." Country Head quarters: ";
$result=mysql_query("select e.country,e.countryid from region as a, regionvc as b, industryvc as c, industry as d, country as e, countryvc as f
where
a.regionid=b.regionid and
b.vcid=c.vcid and
c.vcid=f.vcid and
f.countryid=e.countryid
and a.regionid='$region'
and c.industryid='$industry' group by country",$link);
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();/**/
}/**/
elseif((!isset($_GET['industry']))&&(isset($_GET['country'])))
{
$country=$_GET['country'];
$result=mysql_query("Select country from country where countryid='$country'",$link);
$data=mysql_fetch_row($result);
$countryname=$data[0];
$view=$view."Country Head Quarters:$country ";
$result=mysql_query("select e.industry,e.industryid from region as a , regionvc as b, countryvc as c , country as d , industry as e, industryvc as f
where
a.regionid=b.regionid and
b.vcid=c.vcid and
c.vcid = f.vcid and
f.industryid=e.industryid
and a.regionid='$region'
and c.countryid='$country' group by industry",$link);
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
}
elseif((isset($_GET['industry']))&&(isset($_GET['country'])))
{
$industry=$_GET['industry'];
$country=$_GET['country'];
$result=mysql_query("select industry from industry where industryid='$industry'",$link);
$data=mysql_fetch_row($result);
$industryname=$data[0];
$view=$view."Industry:$industryname ";
$result=mysql_query("select country from country where countryid='$country'",$link);
$data=mysql_fetch_row($result);
$countryname=$data[0];
$view=$view." Country Head Quarters:$countryname ";
$view=$view." Institution: ";
$result=mysql_query("select a.institution , g.website from vcsbn as g, region as b,regionvc as c, industryvc as d,countryvc as e,institutionvc as f, institution as a
where b.regionid=c.regionid and c.vcid=d.vcid and d.vcid=e.vcid and f.vcid=e.vcid and a.institutionid=f.institutionid
and b.regionid='$region' and d.industryid='$industry' and e.countryid='$country' and g.id=f.vcid group by a.institution",$link);
while($data=mysql_fetch_row($result))
{
if ($data[1]!="")
{
$view=$view."| $data[0] | ";
}
else
{
$view=$view."| $data[0] | ";
}
}
$view=$view." ";
display();
}
}
}
if($mode==3)
{
if(!isset($_GET['industry']))
{
$result=mysql_query("Select industry,industryid from industry order by industry",$link);
$view="Industries: ";
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
}
elseif((!isset($_GET['region']))&&(!isset($_GET['country'])))
{
$industry=$_GET['industry'];
$result=mysql_query("Select industry from industry where industryid='$industry'",$link);
$data=mysql_fetch_row($result);
$industryname=$data[0];
$view=$view."Industry:$industryname ";
$result=mysql_query("select d.region,d.regionid from region as d, regionvc as c, industryvc as b, industry as a
where
a.industryid='$industry' and
b.industryid=a.industryid and
b.vcid=c.vcid and
c.regionid=d.regionid group by d.region",$link);
$view=$view."Regions: ";
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
$result=mysql_query("select d.country,d.countryid from country as d, countryvc as c, industryvc as b, industry as a
where
a.industryid='$industry' and
b.industryid=a.industryid and
b.vcid=c.vcid and
c.countryid=d.countryid group by d.country ",$link);
$view=$view."Country Head Quarters ";
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
//echo "working";
}
elseif((isset($_GET['region']))&&(!isset($_GET['country'])))
{
$industry=$_GET['industry'];
$region=$_GET['region'];
$result=mysql_query("Select industry from industry where industryid='$industry'",$link);
$data=mysql_fetch_row($result);
$industryname=$data[0];
$view=$view."Industry:$industryname ";
$result=mysql_query("select region from region where regionid='$region'",$link);
$data=mysql_fetch_row($result);
$regionname=$data[0];
$view=$view."Regional Specialty:$regionname ";
$result=mysql_query("select f.country,f.countryid from country as f,countryvc as e,regionvc as d,industryvc as c where
f.countryid=e.countryid and
e.vcid=d.vcid and
d.vcid=c.vcid and
c.industryid='$industry' and
d.regionid='$region' group by country",$link);
$view=$view."Country Head Quarters: ";
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
}
elseif((!isset($_GET['region']))&&(isset($_GET['country'])))
{
$industry=$_GET['industry'];
$country=$_GET['country'];
$result=mysql_query("Select industry from industry where industryid='$industry'",$link);
$data=mysql_fetch_row($result);
$industryname=$data[0];
$view=$view."Industry:$industryname ";
$result=mysql_query("select country from country where countryid='$country'",$link);
$data=mysql_fetch_row($result);
$countryname=$data[0];
$view=$view."Country Head Quarters:$countryname ";
$result=mysql_query("select f.region,f.regionid from region as f,regionvc as e,countryvc as d,industryvc as c where
f.regionid=e.regionid and
e.vcid=d.vcid and
d.vcid=c.vcid and
c.industryid='$industry' and
d.countryid='$country' group by region",$link);
$view=$view."Regional Specialty: ";
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
}
elseif((isset($_GET['region']))&&(isset($_GET['country'])))
{
$industry=$_GET['industry'];
$country=$_GET['country'];
$region=$_GET['region'];
$result=mysql_query("select industry from industry where industryid='$industry'",$link);
$data=mysql_fetch_row($result);
$industryname=$data[0];
$result=mysql_query("select region from region where regionid='$region'",$link);
$data=mysql_fetch_row($result);
$regionname=$data[0];
$result=mysql_query("select country from country where countryid='$country'",$link);
$data=mysql_fetch_row($result);
$countryname=$data[0];
$view=$view."Industry:$industryname Regional Specialty:$regionname
Country Head Quarters:$countryname Institutions: ";
$result=mysql_query("select f.institution,g.website from institution as f,institutionvc as e,
vcsbn as g, regionvc as d,industryvc as c,countryvc as b where
f.institutionid=e.institutionid and
e.vcid=g.id and
g.id=d.vcid and
d.vcid=c.vcid and
c.vcid=b.vcid and
b.countryid='$country' and
c.industryid='$industry' and
d.regionid='$region' group by f.institution",$link);
while($data=mysql_fetch_row($result))
{
if($data[1]!="")
{
$view=$view."| $data[0] | ";
}
else
{
//echo"here";
$view=$view."| $data[0] | ";
}
}/**/
$view=$view." ";
display();
}
}
if($mode==4)
{
if(!isset($_GET['country']))
{
$result=mysql_query("Select country,countryid from country order by country",$link);
$view="Country Head Quarters: ";
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
}
elseif((!isset($_GET['region']))&&(!isset($_GET['industry'])))
{
$country=$_GET['country'];
$result=mysql_query("Select country from country where countryid='$country'",$link);
$data=mysql_fetch_row($result);
$countryname=$data[0];
$view=$view."Country Head Quarters:$countryname ";
$result=mysql_query("select d.region,d.regionid from region as d, regionvc as c, countryvc as b, country as a
where
a.countryid='$country' and
b.countryid=a.countryid and
b.vcid=c.vcid and
c.regionid=d.regionid group by d.region",$link);
$view=$view."Regions: ";
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
$result=mysql_query("select d.industry,d.industryid from industry as d, industryvc as c, countryvc as b, country as a
where
a.countryid='$country' and
b.countryid=a.countryid and
b.vcid=c.vcid and
c.industryid=d.industryid group by d.industry ",$link);
$view=$view."Industry: ";
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
//echo "working";
}
elseif((isset($_GET['region']))&&(!isset($_GET['industry'])))
{
$country=$_GET['country'];
$region=$_GET['region'];
$result=mysql_query("Select country from country where countryid='$country'",$link);
$data=mysql_fetch_row($result);
$countryname=$data[0];
$view=$view."Country Head Quarters:$countryname ";
$result=mysql_query("select region from region where regionid='$region'",$link);
$data=mysql_fetch_row($result);
$regionname=$data[0];
$view=$view."Regional Specialty:$regionname ";
$result=mysql_query("select f.industry,f.industryid from industry as f,industryvc as e,regionvc as d,countryvc as c where
f.industryid=e.industryid and
e.vcid=d.vcid and
d.vcid=c.vcid and
c.countryid='$country' and
d.regionid='$region' group by industry",$link);
$view=$view."Industry: ";
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
}
elseif((!isset($_GET['region']))&&(isset($_GET['industry'])))
{
$industry=$_GET['industry'];
$country=$_GET['country'];
$result=mysql_query("select country from country where countryid='$country'",$link);
$data=mysql_fetch_row($result);
$countryname=$data[0];
$view=$view."Country Head Quarters:$countryname ";
$result=mysql_query("Select industry from industry where industryid='$industry'",$link);
$data=mysql_fetch_row($result);
$industryname=$data[0];
$view=$view."Industry:$industryname ";
$result=mysql_query("select f.region,f.regionid from region as f,regionvc as e,countryvc as d,industryvc as c where
f.regionid=e.regionid and
e.vcid=d.vcid and
d.vcid=c.vcid and
c.industryid='$industry' and
d.countryid='$country' group by region",$link);
$view=$view."Regional Specialty: ";
while($data=mysql_fetch_row($result))
{
$view=$view."| $data[0] | ";
}
$view=$view." ";
display();
}
elseif((isset($_GET['region']))&&(isset($_GET['industry'])))
{
$industry=$_GET['industry'];
$country=$_GET['country'];
$region=$_GET['region'];
$result=mysql_query("select industry from industry where industryid='$industry'",$link);
$data=mysql_fetch_row($result);
$industryname=$data[0];
$result=mysql_query("select region from region where regionid='$region'",$link);
$data=mysql_fetch_row($result);
$regionname=$data[0];
$result=mysql_query("select country from country where countryid='$country'",$link);
$data=mysql_fetch_row($result);
$countryname=$data[0];
$view=$view."Country Head Quarters:$countryname Industry:$industryname Regional Specialty:$regionname
Institutions: ";
$result=mysql_query("select f.institution,g.website from institution as f,institutionvc as e,
vcsbn as g, regionvc as d,industryvc as c,countryvc as b where
f.institutionid=e.institutionid and
e.vcid=g.id and
g.id=d.vcid and
d.vcid=c.vcid and
c.vcid=b.vcid and
b.countryid='$country' and
c.industryid='$industry' and
d.regionid='$region' group by f.institution",$link);
while($data=mysql_fetch_row($result))
{
if($data[1]!="")
{
$view=$view."| $data[0] | ";
}
else
{
//echo"here";
$view=$view."| $data[0] | ";
}
}/**/
$view=$view." ";
display();
}
}
?>
|
