" . $_GET["name"] . " Venture Capital and Private Equity Financings\n"; ?>

VC-funded Company:

0) { $row = mysql_fetch_array($results, MYSQL_ASSOC); echo "
"; echo "
"; echo "
"; if ($row["imageurl"] != "") { echo "
"; echo "
"; echo ""; echo "
"; echo "
"; } echo "
"; echo "
"; echo "
" . $row["name"] . "
\n"; echo "
\n"; if ($row["address1"] && $row["address1"] !== "") echo "
". $row["address1"] . "
\n"; if ($row["address2"] && $row["address2"] !== "") echo "
" .$row["address2"] . "
\n"; if ($row["city"] && $row["state"]) echo "
". $row["city"] . ", " . $row["state"] . " " . $row["zip"] . "
\n"; else if ($row["state"]) echo "
" .$row["state"] . "
\n"; if ($row["phone"]) echo "
Phone: " . $row["phone"] . "
\n"; if ($row["website"]) { if ($row["website"][0] != 'h') $websitestr = "http://" . $row["website"]; else $websitestr = $row["website"]; echo "" . $row["website"] . "
\n"; } echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
\n"; echo "

" .$row["profile"] . "

\n"; echo "
Key Contact
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "Name
".$row["contactname"].""; echo "
\n"; echo "
\n"; echo "Title
".$row["title"].""; echo "
\n"; echo "
\n"; echo "E-Mail
" . $row["email"] . ""; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; } ?> '2000-01-01' order by date asc"; $eventresults = mysql_query ($sql); $eventIDs = Array(); if ($eventresults != FALSE && mysql_num_rows ($eventresults) > 0){ echo "
\n"; echo "
Funding Events

\n"; echo "
\n"; echo "
\n"; echo "\n"; $i=1; while ($eventrow = mysql_fetch_array($eventresults, MYSQL_ASSOC)){ if($i==1) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; } echo ""; $date = explode("-", $eventrow["date"]); $dateToDisplay = $date[1] . "/" . $date[2] . "/" . substr($date[0], 2); if ($eventrow["amount"] && $eventrow["amount"] != 0){ $amountToDisplay = number_format($eventrow["amount"]); $amountToDisplay = "$" . $amountToDisplay; } else $amountToDisplay = "undisclosed"; if ($eventrow["articleid"] == ""){ echo "\n"; echo "\n"; echo "\n"; } else{ echo "\n"; echo "\n"; 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"; } else { echo ""; } echo ""; $i++; } echo "\n"; echo "
\n"; echo "Date
"; echo "
\n"; echo "Amount
"; echo "
\n"; echo "Type
"; echo "
\n"; echo "Investors
"; echo "
\n"; echo $dateToDisplay.""; echo "\n"; echo $amountToDisplay.""; echo "\n"; echo $eventrow["type"].""; echo "\n"; echo "".$dateToDisplay.""; echo "\n"; echo "".$amountToDisplay.""; echo "\n"; echo "".$eventrow["type"].""; 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
\n"; echo "
\n"; echo "
\n"; } ?>


Featured Reading