<table class="center">
<tr>
<td colspan="2" align="center">
<h3>' . $pid_count . ' Producers</h3>
This list contains <span class="listed">listed</span> and <span class="unlisted">unlisted</span> (but not suspended) producers.
<br />Click here for <a href="prdcr_list.php"><b>Further details about each producer</b></a>
<br />Contact us at <a href="mailto:' . MEMBERSHIP_EMAIL . '">' . MEMBERSHIP_EMAIL . '</a> if your contact information needs to be updated.
<br /><br />
</td>
</tr>
<tr>
<td valign="top" align="left">
' . prdcr_contact_info(0, $pid_half) . '
</td>
<td valign="top" align="left">
' . prdcr_contact_info($pid_half, $pid_count) . '
</td>
</tr>
</table>';
$page_specific_css .= '
<style type="text/css">
table.center {
margin:auto;
}
.listed,
.listed a {
color:#000;
}
.unlisted,
.unlisted a {
color:#888;
FROM
' . TABLE_PRODUCER . '
WHERE
unlisted_producer = "0"';
$result = mysql_query($sql) or die("Couldn't execute query.");
$row = mysql_fetch_array($result);
$pid_count = $row['count'];
$pid_half = ceil($pid_count / 2);
$content_label .= '
<table width="100%" cellspacing="15" cellpadding="1">
<tr>
<td colspan="3" align="center">
<h3>Producer Contact Info for Mailing Labels: ' . $pid_count . ' Producers</h3>
</td>
</tr>
<tr>
<td valign="top" align="left" width="50%">' . prdcr_contact_info(0, $pid_half) . '</td>
<td bgcolor="#000000" width="2"></td>
<td valign="top" align="left" width="50%">' . prdcr_contact_info($pid_half, $pid_count) . '</td>
</tr>
</table>';
$page_title_html = '<span class="title">Reports</span>';
$page_subtitle_html = '<span class="subtitle">Producer Labels</span>';
$page_title = 'Reports: Producer Labels';
$page_tab = 'producer_admin_panel';
include "template_header.php";
echo '
<!-- CONTENT BEGINS HERE -->
' . $content_label . '
<!-- CONTENT ENDS HERE -->';
include "template_footer.php";
