/home/wpollock1/public_html/PHP/myrss.php

<?php
// Downloaded on 12/22/08 from http://www.developer.com/xml/article.php/3113931

      session_start();

      if (! isset($_SESSION['userid']))
      {

           if (! isset($_POST['email']))
           {

                echo "<form action='myrss.php' method='post'>";
                echo "Email:<br />";
                echo "<input type='text' name='email' size='20' maxlength='55' value='' /><br />";
                echo "Password:<br />";
                echo "<input type='password' name='pswd' size='20' maxlength='20' value='' /><br />";
                echo "<input type='submit' value='login'>";
                echo "</form>";

           } else {

               mysql_connect("localhost","aggregator","secret");
               mysql_select_db("rssfeeds");

               $email = $_POST['email'];
               $pswd = md5($_POST['pswd']);

               $query = "SELECT rowID, email, pswd FROM user WHERE email='$email' AND '$pswd'";
               $result = mysql_query($query);

               if (mysql_numrows($result) != 1)
               {
                     echo "<p>Could not login!</p>";
               } else {
                     list($rowID, $email, $pswd) = mysql_fetch_row($result);
                     $_SESSION['userid'] = $rowID;
               }

                mysql_close();

           } // end isset[email]

      }

     if (isset($_SESSION['userid'])) {

          mysql_connect("localhost","aggregator","secret");
          mysql_select_db("rssfeeds");

	      require_once("rss_fetch.inc");

		  $userID = $_SESSION['userid'];

		  $query = "SELECT rss.title, rss.url FROM rssfeed AS rss, user_to_rss_feed as userrss
		            WHERE userrss.userid='$userID' AND rss.rowID=userrss.rssid";

		  $result = mysql_query($query);
		  while(list($title,$url) = mysql_fetch_row($result)) {

               $url = "$url";
               $rss = fetch_rss( $url );

               echo "Channel Title: " . $rss->channel['title'] . "<p>";
               echo "<ul>";
               foreach ($rss->items as $item)
               {
                    $href = $item['link'];
                    $title = $item['title'];
                    echo "<li><a href=$href>$title</a></li>";
	           }

               echo "</ul>";

          }

          mysql_close();

     }

?>