" . $_GET["name"] . " Venture Capital and Private Equity Financings\n"; ?>
" .$row["profile"] . "
\n"; echo "| \n"; echo "Date"; echo " | \n"; echo "\n"; echo "Amount"; echo " | \n"; echo "\n"; echo "Type"; echo " | \n"; echo "\n"; echo "Investors"; echo " | \n"; } echo "||||
|---|---|---|---|---|---|---|---|
| \n"; echo $dateToDisplay.""; echo " | \n"; echo "\n"; echo $amountToDisplay.""; echo " | \n"; echo "\n"; echo $eventrow["type"].""; echo " | \n"; } else{ echo "\n"; echo "".$dateToDisplay.""; echo " | \n"; echo "\n"; echo "".$amountToDisplay.""; echo " | \n"; echo "\n"; echo "".$eventrow["type"].""; echo " | \n"; } $sql = "select distinct investors.name, eventinvestors.isLead from fundingevent join eventinvestors on fundingevent.fid = eventinvestors.fundingid JOIN investors ON eventinvestors.investorid=investors.iid where fundingevent.fid=".$eventrow["fid"]." order by investors.name ASC"; $investorresults = mysql_query ($sql); if (mysql_num_rows ($investorresults) > 0){ $first = true; echo "\n";
while($investorrow = mysql_fetch_array($investorresults, MYSQL_ASSOC)){
if ($first){
echo ''.$investorrow["name"].'';
if ($investorrow["isLead"] == "Y")
{
echo " ";
}
echo ""; $first = false; } else{ echo ''.$investorrow["name"].''; if ($investorrow["isLead"] == "Y") { echo " ";
}
echo ""; } } echo " | \n";
}
else
{
echo "\n | "; } echo "