djjase

I have a api call that extracts data from a datatabase. It looks a bit like this see below:
It is called using a http://xxxxxxxx/xxxxx/get_all

I want to be able to pull this information into a table on another website and display certain text and have that table updated ever few minutes as this api call is updated every 5mins.

Any ideas on how to do this ?

<?xml version="1.0" ?>
- <RSP api="site" request="get_all" ts="1169613448" ts_timezone="Australia/NSW" rc="0">
- <categories>
- <category id="10">
<name>Horse Racing</name>
- <subcategories>
- <category id="3272" parent_id="10">
<name>Ascot</name>
- <events>
- <event id="12590">
<name>1: JUST BEGUN 3YOF CL6 HCP</name>
<datetime tz="Australia/NSW" unix="1169614800">2007-01-24 16:00:00</datetime>
<wp_ref>35</wp_ref>
<parent_category_id>10</parent_category_id>
<category_id>3272</category_id>
<parent_category_name>Horse Racing</parent_category_name>
<category_name>Ascot</category_name>
<race_number>1</race_number>
<racing_event>1</racing_event>
- <markets>
- <market id="39204" primitive_type="8" primitive_name="Racing">
<name>Racing Live</name>
- <bet_types>
- <bet_type id="1">
<name>Win</name>
- <price_types>
- <price_type id="1">
<name>Fixed</name>
<max_stake>250</max_stake>
</price_type>
</price_types>
</bet_type>
- <bet_type id="3">
<name>Win/Place</name>
- <price_types>
- <price_type id="1">
<name>Fixed</name>
<max_stake>125</max_stake>
</price_type>
</price_types>
</bet_type>
</bet_types>

__________________
Looking for something to buy?
www.whatstobuy.com
Has all the items that you want to buy

smilemaker

difficult????

__________________
Software & Scripts with SourceCode & PLR
Great Articles on Various Niche

djjase

tell me aboout it. I was thinking that I would have to caputure the data into say a MYSQL table and then the other website connects to that table to show the information.

My problem is I know nothing about PHP / MYSQL

__________________
Looking for something to buy?
www.whatstobuy.com
Has all the items that you want to buy