hi i have created a database the code which shows the results in coulmn the code is <table align="center" border="1" width="800"> <tr> <td> <table align="center" border="1" width="125%"> <tr bgcolor="#DADADA"> <th>accession no. </th> <th>locus </th> <th> source </th> <th> taxsonamy </th> <th> sequence </th> <th> si RNA sequence </th> <th> uni gene no. </th> <th> submitted information. </th> </tr> <?php if (isset($_GET['act']) and $_GET['act'] == 1) { $search = $_GET['search']; $sql_ser = "SELECT * FROM sirna_table1 WHERE accession_no LIKE '%".trim($search)."%'"; //'%.$search.%'"; $result_ser = mysql_query($sql_ser); //echo mysql_num_rows($result_ser); if (mysql_num_rows($result_ser) > 0) { while($row = mysql_fetch_array($result_ser)) { echo ' <tr bgcolor="#FFFFFF"> <td> '.$row['accession_no'].' </td> <td> '.$row['locus'].' </td> <td> '.$row['source'].' </td> <td> '.$row['taxsonamy'].' </td> <td> <a href="sequence.php?id='.$row['id'].'">'.$row['SEQUENCE'].'</a> </td> <td> '.$row['SiRNA_sequence'].' </td> <td> '.$row['Unigene_number'].' </td> <td> '.$row['Submitters_Information'].' </td> </tr> '; } } } ?> </table> </td> </tr> </table> but want to show results like this ACCESSION NUMBER a field from database LOCUS a field from database so on........ is there some to help me
<table align="centre" border="1" width="12"> <tr bgcolor="#DADADA"> <td>ACCESSION NUMBER</td> </tr> <tr> <td>a field from database</td> </tr> <tr> <td>Locus</td> </tr> <tr> <td>a field from database</td> </tr>