RSS rdb file format parse into DB table; use vBAdvanced and/or AboutToday to display

[itsalltropical]

Need to input the following RSS feed which is in rdb format, hopefully into a database table in vBulletin. Then create a module to display the latest reading on my cmps_index page and maybe at the bottom of all my pages. I am a newbie so I understand the concept; just don't know how to start & finish

I would need step by step instructions since I am so green, i.e
Go to adminCP or MySQL to create table, etc.
Use this code to load table;
Go to cmps and add module, etc.
Use RSS or AboutToday or this code to go get the data every hour or maybe just twice a day.

There are comment lines before the data that start with #. The first row of the data defines the columns. After that is the real data. I would want to load rows into the database that are unique by Date & Time. Each read is usually an hour apart. Then, again my module would display the latest reading with Date, Time and Level.

Here is a paste of the data coming in. URL is: USGS Level @ Lake Murray, SC I don't know how to make this box bigger Maybe a Moderator/Member would teach a newbie how? PM is OK.

PHP Code:

# ---------------------------------- WARNING ----------------------------------------# The data you have obtained from this automated U.S. Geological Survey database# have not received Director's approval and as such are provisional and subject to# revision. The data are released on the condition that neither the USGS nor the# United States Government may be held liable for any damages resulting from its use.# Additional info: http://waterdata.usgs.gov/sc/nwis/help/?provisional## File-format description: http://waterdata.usgs.gov/nwis/?tab_delimited_format_info# Automated-retrieval info: http://waterdata.usgs.gov/nwis/?automated_retrieval_info## Contact: gs-w_support_nwisweb@usgs.gov# retrieved: 2007-01-08 11:21:12 EST## Data for the following site(s) are contained in this file# USGS 02168500 LAKE MURRAY NEAR COLUMBIA, SC# -----------------------------------------------------------------------------------## Data provided for site 02168500# DD parameter Description# 13 00065 Gage height, feet#agency_cd    site_no    datetime    13_00065    13_00065_cd5s    15s    16s    14s    14sUSGS    02168500    2007-01-07 00:00    357.00    USGS    02168500    2007-01-07 01:00    356.98    USGS    02168500    2007-01-07 02:00    357.00    USGS    02168500    2007-01-07 03:00    357.01    USGS    02168500    2007-01-07 04:00    357.02    USGS    02168500    2007-01-07 05:00    357.02    USGS    02168500    2007-01-07 06:00    357.03    USGS    02168500    2007-01-07 07:00    357.06    USGS    02168500    2007-01-07 08:00    357.04    USGS    02168500    2007-01-07 09:00    357.06    USGS    02168500    2007-01-07 10:00    357.07    USGS    02168500    2007-01-07 11:00    357.09    USGS    02168500    2007-01-07 12:00    357.07    USGS    02168500    2007-01-07 13:00    357.11    USGS    02168500    2007-01-07 14:00    357.13    USGS    02168500    2007-01-07 15:00    357.12    USGS    02168500    2007-01-07 16:00    357.13    USGS    02168500    2007-01-07 17:00    357.15    USGS    02168500    2007-01-07 18:00    357.16    USGS    02168500    2007-01-07 19:00    357.16    USGS    02168500    2007-01-07 20:00    357.18    USGS    02168500    2007-01-07 21:00    357.20    USGS    02168500    2007-01-07 22:00    357.21    USGS    02168500    2007-01-07 23:00    357.23    USGS    02168500    2007-01-08 00:00    357.22    USGS    02168500    2007-01-08 01:00    357.25    USGS    02168500    2007-01-08 02:00    357.23    USGS    02168500    2007-01-08 03:00    357.24    USGS    02168500    2007-01-08 04:00    357.29    USGS    02168500    2007-01-08 05:00    357.29    USGS    02168500    2007-01-08 06:00    357.34    USGS    02168500    2007-01-08 07:00    357.36    USGS    02168500    2007-01-08 08:00    357.38 


[itsalltropical]

I've got the data down to three lines after the comments which start with a #. I just need the last line of data which has date, time and level. For some reason when I put the data within the php tags it is wrapping the last line. Can anyone help me?

At this point I'll even take just pulling the last line of data and displaying it within some text like "Lake Murray Level @ xxx on date time". Whatever is easiest. Display it, create a post in News forum, etc.

Here's the new URL with the reduced amount of data. I just need to post date time level (which in the example below is 357.30. Would like to automagically pull it twice a day.
USGS Lake Murray

PHP Code:

#
# U.S. Geological Survey
# National Water Information System
# Retrieved: 2007-01-09 19:37:20 EST
#
# ---------------------WARNING---------------------
# The data you have obtained from this automated
# U.S. Geological Survey database have not received
# Director's approval and as such are provisional
# and subject to revision.  The data are released
# on the condition that neither the USGS nor the
# United States Government may be held liable for
# any damages resulting from its use.
#
# Further Descriptions of the parameter_cd column can be found at:
# http://waterdata.usgs.gov/nwis/pmcodes
# Further Descriptions of codes in the result_va column can be found at:
# http://waterdata.usgs.gov/nwis/help?codes_help
#
# This information includes the following fields:
#
#  agency_cd    Agency Code
#  station_nm   Station Name
#  site_no      USGS station number
#  dd_nu        Data Descriptor Number
#  parameter_cd Parameter Code
#  result_dt    Date that the result was taken
#  result va    Current value 
#  result_cd    Code to show data quality
#  result_md    Date the result was modified in the NWIS database
#
agency_cd    site_no    dd_nu    parameter_cd    result_dt    result_va    result_cd    result_md
5s    15s    2n    5s    12d    12s    2s    12d
USGS    02168500    13    00065  2007-01-09   16:00:00    357.30