html to mysql i wanna learn this quickly

Discussion in 'MySQL' started by arunsuriindia, Mar 31, 2007.

0
  1. #1
    <meta name="ProgId" content="FrontPage.Editor.Document">
    <title>Top 5 Losers</title>
    </head>

    <body>

    <table>
    <tr>
    <td vAlign="top" align="right"><br>
    <table cellSpacing="0" cellPadding="0" width="100%" bgColor="#969696" border="0">
    <tbody>
    <tr>
    <td>
    <table cellSpacing="1" cellPadding="4" width="100%" border="0">
    <tbody>
    <tr>
    <td class="tablehead" colSpan="9">Top 5 Losers</td>
    </tr>
    <tr align="middle">
    <td class="specialhead2">Symbol</td>
    <td class="specialhead2">Open</td>
    <td class="specialhead2">High</td>
    <td class="specialhead2">Low</td>
    <td class="specialhead2">Prev. Close</td>
    <td class="specialhead2">Last Price</td>
    <td class="specialhead2"><nobr>% Change</nobr></td>
    <td class="specialhead2"><nobr>Last Ex-date &nbsp;&nbsp;</nobr></td>
    <td class="specialhead2">Last<br>
    Corporate Action</td>
    </tr>
    <tr>
    <td class="t0"><a href="http://nseindia.com/marketinfo/equities/cmquote.jsp?key=BPCLEQN&amp;symbol=BPCL&amp;flag=0">BPCL</a></td>
    <td class="t1">320.30</td>
    <td class="t1">320.30</td>
    <td class="t1">301.10</td>
    <td class="t1">312.65</td>
    <td class="t1">302.75</td>
    <td class="t1">-3.17</td>
    <td class="t0">15-JAN-07</td>
    <td class="t0">INTERIM DIVIDEND - 60%</td>
    </tr>
    <tr>
    <td class="t0"><a href="http://nseindia.com/marketinfo/equities/cmquote.jsp?key=HCLTECHEQN&amp;symbol=HCLTECH&amp;flag=0">HCLTECH</a></td>
    <td class="t1">300.40</td>
    <td class="t1">302.80</td>
    <td class="t1">284.00</td>
    <td class="t1">300.40</td>
    <td class="t1">291.40</td>
    <td class="t1">-3.00</td>
    <td class="t0">15-MAR-07</td>
    <td class="t0">BONUS 1:1</td>
    </tr>
    <tr>
    <td class="t0"><a href="http://nseindia.com/marketinfo/equities/cmquote.jsp?key=JETAIRWAYSEQN&amp;symbol=JETAIRWAYS&amp;flag=0">JETAIRWAYS</a></td>
    <td class="t1">647.35</td>
    <td class="t1">663.00</td>
    <td class="t1">628.00</td>
    <td class="t1">650.15</td>
    <td class="t1">633.20</td>
    <td class="t1">-2.61</td>
    <td class="t0">07-SEP-06</td>
    <td class="t0">AGM/DIV-RS.6/- PER SH</td>
    </tr>
    <tr>
    <td class="t0"><a href="http://nseindia.com/marketinfo/equities/cmquote.jsp?key=HDFCEQN&amp;symbol=HDFC&amp;flag=0">HDFC</a></td>
    <td class="t1">1535.90</td>
    <td class="t1">1539.95</td>
    <td class="t1">1501.25</td>
    <td class="t1">1537.85</td>
    <td class="t1">1519.80</td>
    <td class="t1">-1.17</td>
    <td class="t0">30-JUN-06</td>
    <td class="t0">AGM/DIV-RS.20/- PER SH</td>
    </tr>
    <tr>
    <td class="t0"><a href="http://nseindia.com/marketinfo/equities/cmquote.jsp?key=TCSEQN&amp;symbol=TCS&amp;flag=0">TCS</a></td>
    <td class="t1">1248.35</td>
    <td class="t1">1254.80</td>
    <td class="t1">1220.25</td>
    <td class="t1">1248.35</td>
    <td class="t1">1233.85</td>
    <td class="t1">-1.16</td>
    <td class="t0">22-JAN-07</td>
    <td class="t0">3RD INT DIV-RS.3/- PER SHPURPOSE REVISED</td>
    </tr>
    </tbody>
    </table>
    </td>
    </tr>
    </tbody>
    </table>
    </td>
    </tr>
    <!-- <tr><td colspan=3 class=smalllinks><ul><li>% change is w.r.t. Prev. Close</li><li>If today is Ex-Date, % change is w.r.t. Open Price</li></ul></td></tr> -->
    </table>

    </body>

    </html>


    here is the sample of a small table now how do i convert it to mysql

    especially the merged cells
     
    arunsuriindia, Mar 31, 2007 IP
  2. Pat Gael

    Pat Gael Banned

    Messages:
    1,331
    Likes Received:
    68
    Best Answers:
    0
    Trophy Points:
    0
    #2
    There are a few problems with your request:

    1. you are using frontpage to workd with tables?
    2. which is you actual database?
    3. or do you want to create a database using the above html values?
     
    Pat Gael, Apr 1, 2007 IP
  3. arunsuriindia

    arunsuriindia Peon

    Messages:
    61
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    the above is a data in html table
    i want to put this data in to a mysql database
     
    arunsuriindia, Apr 1, 2007 IP