<?
 require_once ('rss_fetch.inc');

 ////////////////////////////////////////////////////////////////////
 // Fill in this section:
 ///////////////////////////////////////////////////////////////////

 //url of rss feed
 $rss_url="http://www.silvercash.com/rss/?a=1014249&p=8&s=984";

 
 // set to 0 to supress debug messages
 $debug_on=1;

 //example:
 //  Databas table contains hosted gallery links organized in two
 //  fields: webdsc and weburl.
 //  script will populate rss title tag to webdesc and 
 //  rss link title to weburl
 //  add as many rss/db filed pairs as needed for your application
 //  to the array definition below

 $rss_field_array = array ("link", "title");
 $db_field_array  = array ("weburl", "webdesc");

 // database config 
 // in this example the database is the monkey TGP script
 $db_host="localhost";
 $db_user="root";
 $db_pass="password";
 $db_name="monkey";
 $db_table="fm_tgpgalleries";

 //figure out how many items are in the array
 $rss_field_array_count = count($rss_field_array);
 $db_field_array_count = count($db_field_array);


 //////////////////////////////////////////////////////////////////////////
 // No changes needed in the rest of the code
 /////////////////////////////////////////////////////////////////////////

 // create a string of the db_field names for use in the INSERT function
 $i=1;
 $db_field_string="(".$db_field_array[0];
 while ($i < $db_field_array_count)
   {
    $db_field_string .=",".$db_field_array[$i];
    $i++;         
   }
 $db_field_string .=")";
 if ($debug_on) { echo "db_field_string = $db_field_string\n\n"; }      

 $Connection=mysql_connect($db_host, $db_user, $db_pass) or die ("Failed to connect to database");
 mysql_select_db ("$db_name") or die ("Failed to select database");

 $rss = fetch_rss ($rss_url);
 foreach ($rss->items as $item) 
    {
       $rss_field_idx = 0;
       foreach ($rss_field_array as $rss_field_name)
       {
          $val[$rss_field_idx]=$item[$rss_field_name];
          echo "$val[$rss_field_idx],";
          $rss_field_idx++;
       }
       $pri_key = $item[$rss_field_array[0]];
       $result = mysql_query ("SELECT * FROM $db_table WHERE $db_field_array[0]='$pri_key' LIMIT 1") or
                      die ("pri key query failed");
       if (mysql_fetch_array($result))
       {
        if ($debug_on) { echo "already in the database"; }
       }
       else
       {
        $i=1;
        $val[0]=addslashes($val[0]);
        $db_data_string="('".$val[0]."'";
        while ($i < $rss_field_idx)
         {
          $val[$i]=addslashes($val[$i]);
          $db_data_string .=",'".$val[$i]."'";
          $i++;         
         }
        $db_data_string .=")";
        if ($debug_on) {  echo ("db_data_string = $db_data_string");  }
        mysql_query ("INSERT INTO $db_table $db_field_string VALUES $db_data_string") or die
         ("Failed to perform insert");
       }
         echo ("\n");
    }


?>