output from databse

Discussion in 'Databases' started by Zee01, Jul 7, 2010.

  1. #1
    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
     
    Zee01, Jul 7, 2010 IP
  2. Karthickraj

    Karthickraj Greenhorn

    Messages:
    53
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    18
    #2
    <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>
     
    Karthickraj, Jul 9, 2010 IP