// old table including db call

///////////////////////////////

<table class="tabledata dataDB fulltable centersort" cellspacing="0" width="100%">
    <thead>
        <tr>
        	<th style="display:none;">Genomic Position</th>
            <th>Location</th>
<!--            <th>Codon Number</th>
-->            <th>Genotype (cDNA)</th>
            <th>Codon Change</th>
            <th>Protein Change</th>
            <th>Classification</th>
            <th>MEN2 Phenotype</th>
            <th>MTC Onset</th>
            <th>References</th>
            <th>Comments</th>
        </tr>
    </thead>
    <tbody>
<?php
# generate SQL query string
$sql = "SELECT variant_id, genomic_position, location, codon_change, amino_change, genotype, classification, men_phenotype, age_onset, link_url, link_text, comments FROM MEN2 ORDER BY genomic_position";

# execute SQL query and display result set
$result = $db->execute($sql);
while ($row = $db->getrowassoc($result)) {
?>	
    <tr>
    	<td style="display:none;"><?php echo $row["genomic_position"]; ?></td>
		<td><?php echo $row['location']; ?></td>
        <td><?php echo $row['genotype']; ?></td>
        <td><?php echo $row['codon_change']; ?></td>
        <td><?php echo $row['amino_change']; ?></td>
		<td><?php echo $row['classification']; ?></td>
        <td><?php echo $row['men_phenotype']; ?></td>
        <td><?php echo $row['age_onset']; ?></td>
<?php
# display reference links if any
	if(isset($row['link_text']) && isset($row['link_url'])){
	?>
		<td><a target='_blank' href="<?php echo $row['link_url']; ?>"><?php echo $row['link_text']; ?></a></td>
	<?php	
	} else {
	?>
		<td>&nbsp;</td>
	<?php
	}

# add comments if any
	if(!empty($row['comments'])){
	?>
		<td align='center'><a class="tooltip" title="<?php echo $row["comments"]; ?>"><img src="/newsite/images/icons/comment.gif"></a></td>
	<?php
	} else {
	?>
		<td>&nbsp;</td>
	<?php
	}
}
?>
	</tr>
</tbody>
</table>