Collecting Info Off Another Website
Posted: Tue Dec 04, 2012 5:21 am
Hi
I have been given permission to use a table located on another website and wanting the data extracted and inserted in my database, the table is as follows:
which method would be best to extract the data ?
I have been given permission to use a table located on another website and wanting the data extracted and inserted in my database, the table is as follows:
Code: Select all
<table>
<tr><th>Indicative Rates</th>
<th>Sell</th>
<th>Buy</th>
</tr>
<tr>
<td>GBPEUR</td>
<td>1.2316</td>
<td>1.2336</td>
</tr>
<tr>
<td>GBPUSD</td>
<td>1.6109</td>
<td>1.6129</td>
</tr>
<tr>
<td>EURUSD</td>
<td>1.3067</td>
<td>1.3087</td>
</tr>
<tr>
<td>GBPJPY</td>
<td>131.9240</td>
<td>132.3240</td>
</tr>
<tr>
<td>GBPAUD</td>
<td>1.5381</td>
<td>1.5401</td>
</tr>
<tr>
<td>GBPNZD</td>
<td>1.9539</td>
<td>1.9559</td>
</tr>
<tr>
<td>GBPCAD</td>
<td>1.6009</td>
<td>1.6029</td>
</tr>
<tr>
<td>NZDUSD</td>
<td>0.8238</td>
<td>0.8252</td>
</tr>
<tr>
<td>GBPZAR</td>
<td>14.2347</td>
<td>14.2747</td>
</tr>
<tr>
<td>USDZAR</td>
<td>8.8336</td>
<td>8.8536</td>
</tr>
<tr>
<td>GBPPLN</td>
<td>5.0818</td>
<td>5.1018</td>
</tr>
<tr>
<td>EURJPY</td>
<td>106.9922</td>
<td>107.3922</td>
</tr>
<tr>
<td colspan=3><nobr>Rates up-to-date at 4th December 2012 10:51:20am</nobr></td>
</tr>
</table>