';
$f = fopen($data, "rb") or die("Can't open csv");
fgets($f, 4096); //junk the header line
$cameras = array();
$lenses = array();
$panohead = array();
$tripod = array();
$software = array();
while($row = fgetcsv($f, 4096)) {
if(count($row) > 5 && $row[2] != "") {
if(!isset($cameras[$row[1]])) $cameras[$row[1]] = array();
$cameras[$row[1]][] = $row[0];
if(!isset($cameras[$row[1]])) $lenses[$row[2]] = array();
$lenses[$row[2]][] = $row[0];
if(!isset($cameras[$row[1]])) $panohead[$row[3]] = array();
$panohead[$row[3]][] = $row[0];
if(!isset($cameras[$row[1]])) $tripod[$row[4]] = array();
$tripod[$row[4]][] = $row[0];
if(!isset($cameras[$row[1]])) $software[$row[5]] = array();
$software[$row[5]][] = $row[0];
}
}
arsort($cameras);
arsort($lenses);
arsort($panohead);
arsort($tripod);
arsort($software);
doit("Cameras", $cameras);
doit("Lenses", $lenses);
doit("Panoheads", $panohead);
doit("Tripods", $tripod);
doit("Software", $software);
function doit($a, $b) {
global $event;
echo "\n";
echo "\n";
foreach($b as $k=>$v) {
//if($v==1) break;
$s = count($v);
$links = array();
foreach($v as $i) {
$links[] = "{$i}";
}
$links = implode(", ", $links);
echo " | {$k} | {$s} | {$links} |
\n";
}
echo "
\n\n";
}
echo '