Broadcast HDTV Programming

            <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>'.