Re: simple question...

[Larry Brown]

Not sure if all my braces are correct here. Hard to read without the formatting. You should get the idea though.


$domain_query.= $wclause_sql . " AND datab.name='UNIPROT' ";
$domain_result = mysql_query($domain_query) or die(mysql_error());


//print results in HTML
echo "<table width='75%' border=2 cellpading=1>";
echo "<tr>";
echo "<td align = \"center\"colspan=\"2\">Pattern search results</td>";
echo "</tr>";

if(@mysql_num_rows($domain_result) == 0) {

echo '<tr><td>Sorry, No records Found</td></tr>

} else {
while ( $line = mysql_fetch_array($domain_result, MYSQL_ASSOC) ) {

echo "<tr>";

foreach ($line as $col_value) {

echo "<td width = \"50%\">$col_value</td>"
."<td width = \"50%\"><a href ='retrieve_entry.php?code=".$col_value."'>view entry</td>";

}

echo "</tr>";

}

}

}

echo '</table> // close the table.