title: Read HTML table and input data into MySQL database
body: <p>I have a HTML page</p>
  
  <pre><code>table.html
  &lt;table border="1"&gt;
  &lt;tr&gt;
  &lt;td&gt;row 1, cell 1&lt;/td&gt;
  &lt;td&gt;row 1, cell 2&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
  &lt;td&gt;row 2, cell 1&lt;/td&gt;
  &lt;td&gt;row 2, cell 2&lt;/td&gt;
  &lt;/tr&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>I want to be able to <code>lynx -dump</code> this page and insert the data from the html table into a mysql database (The HTML page will always have the same headings but the data will change daily.</p>
  
  <p>I would like to get this script going and then add to a cron so I don't have to manually input the data as i am at the moment!</p>
  
  <p>Does anybody know anyway to do this as I am really stuck at the moment.</p>
  
  <p>Thanks</p>