/var/www/html/programming/broadcast.php
<td class="type1b_header" style="width:20px;"><img src="/images/logos/ind_15.gif" alt="Independent"></td>
<td class="type1b_header" style="width:20px;"><img src="/images/logos/nbc_15.gif" alt="NBC"></td>
<td class="type1b_header" style="width:20px;"><img src="/images/logos/pbs_15.gif" alt="PBS"></td>
<td class="type1b_header" style="width:20px;"><img src="/images/logos/uni_15.gif" alt="Univision"></td>
<td class="type1b_header"><b>Total</b></td>
</tr>
<?
$x = 0;
$sql = "
SELECT dma_name, dma_rank, affiliation_1
FROM prog_source
WHERE dma_name <> ''
ORDER BY dma_name";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$dma_name = $row['dma_name'];
$affil = strtolower(strleft($row['affiliation_1'] .' ', ' '));
$dma_rank[$dma_name] = $row['dma_rank'];
$dma_array[$dma_name] += 1;
$abc[$dma_name] += ($affil == 'abc') ? 1 : 0;
$cbs[$dma_name] += ($affil == 'cbs') ? 1 : 0;
$cw[$dma_name] += ($affil == 'cw') ? 1 : 0;
$fox[$dma_name] += ($affil == 'fox') ? 1 : 0;
# $ind[$dma_name] += ($affil == 'independent') ? 1 : 0;
$ind[$dma_name] += ($affil == 'ind') ? 1 : 0;
$nbc[$dma_name] += ($affil == 'nbc') ? 1 : 0;
# $paxtv[$dma_name] += ($affil == 'paxtv') ? 1 : 0;
$pbs[$dma_name] += ($affil == 'pbs') ? 1 : 0;
# $uni[$dma_name] += ($affil == 'univision') ? 1 : 0;
$uni[$dma_name] += ($affil == 'uni') ? 1 : 0;
# $upn[$dma_name] += ($affil == 'upn') ? 1 : 0;
# $wb[$dma_name] += ($affil == 'wb') ? 1 : 0;
}
foreach($dma_array as $dma_name => $total) {
echo '<tr onmouseover="hover_over(this)" onmouseout="hover_out(this)">'.
' <td class="grid" style="text-align:left"><a href="broadcast-market.php?dma_name[]='. urlencode($dma_name) .'">'. $dma_name .'</a></td>'.
' <td class="grid" style="text-align:right">'. $dma_rank[$dma_name] .'</td>'.
/var/www/html/programming/broadcast.php
<td class="type1b_header" style="width:20px;"><img src="/images/logos/ind_15.gif" alt="Independent"></td>
<td class="type1b_header" style="width:20px;"><img src="/images/logos/nbc_15.gif" alt="NBC"></td>
<td class="type1b_header" style="width:20px;"><img src="/images/logos/pbs_15.gif" alt="PBS"></td>
<td class="type1b_header" style="width:20px;"><img src="/images/logos/uni_15.gif" alt="Univision"></td>
<td class="type1b_header"><b>Total</b></td>
</tr>
<?
$x = 0;
$sql = "
SELECT dma_name, dma_rank, affiliation_1
FROM prog_source
WHERE dma_name <> ''
ORDER BY dma_name";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$dma_name = $row['dma_name'];
$affil = strtolower(strleft($row['affiliation_1'] .' ', ' '));
$dma_rank[$dma_name] = $row['dma_rank'];
$dma_array[$dma_name] += 1;
$abc[$dma_name] += ($affil == 'abc') ? 1 : 0;
$cbs[$dma_name] += ($affil == 'cbs') ? 1 : 0;
$cw[$dma_name] += ($affil == 'cw') ? 1 : 0;
$fox[$dma_name] += ($affil == 'fox') ? 1 : 0;
# $ind[$dma_name] += ($affil == 'independent') ? 1 : 0;
$ind[$dma_name] += ($affil == 'ind') ? 1 : 0;
$nbc[$dma_name] += ($affil == 'nbc') ? 1 : 0;
# $paxtv[$dma_name] += ($affil == 'paxtv') ? 1 : 0;
$pbs[$dma_name] += ($affil == 'pbs') ? 1 : 0;
# $uni[$dma_name] += ($affil == 'univision') ? 1 : 0;
$uni[$dma_name] += ($affil == 'uni') ? 1 : 0;
# $upn[$dma_name] += ($affil == 'upn') ? 1 : 0;
# $wb[$dma_name] += ($affil == 'wb') ? 1 : 0;
}
foreach($dma_array as $dma_name => $total) {
echo '<tr onmouseover="hover_over(this)" onmouseout="hover_out(this)">'.
' <td class="grid" style="text-align:left"><a href="broadcast-market.php?dma_name[]='. urlencode($dma_name) .'">'. $dma_name .'</a></td>'.
' <td class="grid" style="text-align:right">'. $dma_rank[$dma_name] .'</td>'.